Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access+training - Linking to non-Access table

Resolved · Low Priority · Version Standard

Reply 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.

For upcoming training course dates see: Pricing & availability

Reply 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

Access articles

· It's so easy to Access the information you need
· Discover How To Link An Excel Spreadsheet To An Access Database
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· Making Figures Talk For Themselves Thanks To Access
· Access VBA Training Adds Power to your Databases

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips