access+training - Linking to non-Access table

The UK's most regular instructor-led training courses.
Training information: access+training · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Linking to non-Access table

Beverley has attended:
Access Introduction course

by - delegate Beverley [1 post] (2007 Feb 26 Mon, 09:55) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Linking to non-Access table

by - trainer Carlos gold contributer [479 posts] (2007 Feb 26 Mon, 16:53) Edited on 2007 Feb 26 Mon, 16:54 Reply

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

· Microsoft Access Training Unleashes the Power of the Pivot Table
· When Is Microsoft Access Not The Best Choice For Your Business?
· Material covered on a Microsoft Access Course
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Get More Out of MS Access Courses

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips