SQL Back End - Access Front End

[TheNovice]

All,

I have a need/Challenge to move all of our Access Databases and convert them
to SQL but keeping Access as the front end for all of the users.

Can anyone guide me to the right direction on how to accomplish this?

Thanks in advance,

 

[Rick A.B.]

All,

I have a need/Challenge to move all of our Access Databases and convert them
to SQL but keeping Access as the front end for all of the users.

Can anyone guide me to the right direction on how to accomplish this?

Thanks in advance,
--
-The Novice
Learn Today, Teach Tomorrow

Great Success is ones ability to ask for Help.

I would suggest downloading SQLexpress and playing with that. I made
a copy of my FE and a Copy of my BE, linked copy of FE and copy of BE
together and used the Upsizing wizzard in access. It worked
perfectly. Had to make a few changes in the code in FE after testing
but just minor changes.
Hope that helps.

Rick

 

[Tony Toews [MVP]]

I have a need/Challenge to move all of our Access Databases and convert them
to SQL but keeping Access as the front end for all of the users.

Why? IT Nazis complaining?

You can use the upsizing wizard but the SSMA may work better.

There is a new tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/default.mspx However
it only supports SQL Server 2005.

If you are using SQL Server 2000 then you could install SQL Server
Express on your system and then run some SQL Server utilities to
create schema scripts which you could then execute on SQL Server 2000.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/