Modify ODBC Connection created from Upsizing Wizard

S

Steven Wong

I recently tried to migrate an Access 2003 database to a SQL Server 2000
database using the Upsizing Wizard. Migration was successful without any
errors. But I could not figure out where is the ODBC connection (which links
to the migrated SQL tables) created and located. There will be a time when
the backend database is moved from the current development database to a
production database that I will have to change the ODBC connection on the
user's pc to point to the production database.

Also, what are the pros/cons of having a frontend Access 2003 versus ADP
Access 2003 in an application connecting to a backend SQL Server 2000
database?

Your prompt response is very much appreciated.
 
D

Douglas J Steele

Normally, the ODBC connection information is stored in the DSN that's used
when building the connection string. When that's the case, you need to
ensure that each user has a copy of the same DSN.

It's usually easier to have a DSN-less connection. I should one way to do
that at http://www.accessmvp.com/djsteele/DSNLessLinks.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top