sql server new users: I have used Microsoft Access for several years and my company now has
SQL server. I know that I can upsize my Access databases to SQL but I
have learned this is not the best idea.

What should I use to create the front-end to my data? It seems there are
so many options and I want to spend what little time I have learning a
good solution.

Hi,

First best option for easy to code and faster you could have the Access as
the front end itself. My best recommendation for you is to go to Visual
Studio 2005.
But you will have learn the concepts of .NET before you rewrite your
application.

Thanks
Hari

[quoted text, click to view]

For the short term, you can continue using Access as a front end and SQL
Server as the back end. Check out "How to create an Access ADP". (And the
'Upsizing' Wizard isn't too bad -you just have to expect that it isn't
perfect and that you may have to 'fine tune' the results. At least use it to
give yourself a few 'trial runs' and learn from what it does and doesn't do
for you.)

For furture development, you may wish to begin learning and moving toward
Visual Basic.NET. It will be very similar to the VBA used with Access, and
eventually, with some study, you will be able to migrate your current Access
projects and create new projects using VB.NET.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

Here are some places to start:

http://office.microsoft.com/en-us/access/HP052731031033.aspx
http://office.microsoft.com/en-us/access/HA101679531033.aspx


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

Here are some places to start:

http://office.microsoft.com/en-us/access/HP052731031033.aspx
http://office.microsoft.com/en-us/access/HA101679531033.aspx


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

Thanks for the info. Where would I find "Hoe to create an Access ADP"?

[quoted text, click to view]