change table link properties

  • Thread starter MSSQLServerDeveloper
  • Start date
M

MSSQLServerDeveloper

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?
 
A

Albert D. Kallal

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.
 
Top