O'Reilly logo

Microsoft® Office Access 2003 Step by Step by Online Training Solutions Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Linking a Database to Information in Another Database

Linking a Database to Information in Another Database

Instead of importing data into an Access database from another program, you can leave the data in the other program and link to it. Although working with data that is stored in your own database is faster, safer, and more flexible, sometimes linking is preferable.

The most common reason for linking to data in another Access database or a different program is because you don’t own the data. Perhaps another department in your organization maintains the data in a SQL database, and they are willing to give you permission to read the tables and queries but not to change them. Other reasons are security ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required