Moving from access to SQL

a.phillips

Registered User.
Local time
Today, 07:38
Joined
Jul 19, 2011
Messages
37
I am currently running all of my databases off Access 97. We want to move all of the information over so that it is stored on SQL Management studio 2008, but will run off the access 2003 interface if possible.

What is the best way to do this? Are there any tutorials, or programs out there which will help me do this?

I have been following a set of instructions (which I have attached), but when I open the database it does not run as it should as far too many errors occur. I belive that this may possibly be to do with the OBDC links for the tables or possibly that access 2003 requires a more update coding langaue (unsure if this is the case).

Sorry if parts are not very clear, if you need to know anything else just ask, thanks for your help in advance
 

Attachments

Users who are viewing this thread

Back
Top Bottom