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

Chapter 19. Linking Access Front-Ends to... > Linking Client/Server Tables Manuall...

Linking Client/Server Tables Manually

As mentioned in the earlier “Examining the ODBC Table Connection String” section, you must create an ODBC data source when you use the Upsizing Wizard with an existing SQL Server database. You also must create a DSN when you manually export Jet tables to an RDBMS other than SQL Server, and then link the tables to your Jet front end. The number and appearance of the dialogs varies according to the ODBC driver you use to make the connection to the existing database on the RDBMS.

After you create the DSN, you can use the upsizing Wizard to add new tables to an SQL Server database. For other RDBMSs, you must manually export your Jet tables to the database. You use the same DSN to export the data from and attach the tables to your Jet front end.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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