Set MS Access As An Interface to Access Other Database

MS Access can act as an stand alone database or an interface to access ther database, or a database consists of both local tables and linked tables. To set up such links after you have been granted the access to database from DBA, do follows:

1. In Windows' Administrative Tools, click Data Source (ODBC) to set up the link.
2. In MS Access, Click External Data menu.
3. In Import, click More to find out the ODBC Database.
4. Select all tables you need.

A Key Point in Microsoft ODBC Setting

In Microsoft SQL Server DSN Configuration window, select “Change the default database to” is very important. Else, even test shows no error, database linkage may still have problem.