change table link properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been tasked with upgrading a MS Access application to have a SQL
Server Backend. Is there any way of changing all table links at one time or
do I have to do them 1-by-1?
 
You don't mention what verison of ms-acess, but the upsizing wizard will do
this for you, and even move the data...

In recent verisons, you can go:

tools->database utilities->Upsizing wizard.
 
You must log in or register to reply here.

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

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Ghost references to deleted tables in a back end database (Access2000 XP) 5
Record-Locking remains open after closing 0
Linked Tables 3
linking from access to SQL tables 4
Access and SQLServer Express 2005 3
Relinking Tables *Problem 2
Best way to deploy Access read-only database that is linked to SQL tables 6

Back
Top