Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training - Linking to non-Access table

access+training - Linking to non-Access table

ResolvedVersion Standard

Mon 26 Feb 2007, 09:55 Delegate Beverley said...

Beverley has attended:
Access Introduction course

Linking to non-Access table

How do I link to a non-Access table (database is called Solomon - is there any quick way to link to it) ?
Thanks.

Mon 26 Feb 2007, 16:53 Edited on Mon 26 Feb 2007, 16:54 Trainer Carlos said...

RE: Linking to non-Access table

The Solomon Database uses SQL so follows the ODBC protocols.

To link to an ODBC database:

Select File, Get External Data, Link Tables

In the Link dialog box Select ODBC Databases in Files Of Type

Select the required Database and click OK

In the Link Tables dialog box, select the required tables and click OK

The tables appear in your database as linked (With the linked symbol net to each

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

access+training - Linking to non-Access table

Linking to non-Access table

RE: Linking to non-Access table

Access articles

Access tip:

Choosing data types in Access