Access is a desktop database, and you can store data and interface objects in the same file. But most developers agree that a split database is easier to protect and maintain. When you split an ...

Linking Vs. Importing Files in Access. Microsoft introduced its Access database product about 20 years ago, and it remains popular due to its ability to link and import data from a variety of sources.

In Access 2010, click the File tab and then click Options (under Help); in 2007, click the Office button and then click Access Options. Choose Current Database in the left pane.