Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Wednesday, June 10, 2009 – Permalink –

Automaticaly Setup a Database

Link in a snap

When you're creating a new database that will link to data that isn't in an Access format, you can speed up the setup process.

Rather than creating a new database and then using the File>Get External Data>Link Tables,

Choose File>Open from the menu bar
Select the appropriate data format from the Files Of Type dropdown list
Open the file as you would any Access database

Access will automatically create an MDB file with the same name as the data source you selected and will set up links to the data.

[Edited entry from 4/24/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:53 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link