• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Linking Access Front-Ends to... > Moving the Upsized Database to Anoth...

Moving the Upsized Database to Another Server

If you upsize the database on a local instance of MSDE 2000 and then decide to move the database to another server, be prepared to add a substantial amount of VBA code to your project to regenerate the links. There’s no Access wizard or utility to automatically change the SERVER=SERVERNAME element of a DSN-less connection string for each linked table.

Caution

Don’t try to use the Linked Table Manager database utility to change the server name in a DSN-less connection string. The Linked Table Manager requires an ODBC user or system DSN, or a file data source, instead of modifying the current DSN-less connection string. If you use the Linked Table manager to change the link, you must set up a machine DSN on each user’s computer or create a file data source on the server and specify the Uniform Naming Convention (UNC) path to the file in the connection string. The ChangeServer procedure requires at least one DSN-less connection to change DSN connections.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint