98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
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
Resolved · Low Priority · Version Standard
Mon 26 Feb 2007, 09:55Delegate 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:54Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Creating Parameter wildcard queriesTo creat a parameter query that also uses a wildcard, in the query design type in like []+*. |
