Austlink Help Centre

Follow

Microsoft Access - Linking a Database to a New ODBC Connection

Here are the instructions for linking a MS Access database / query to a new ODBC connection:

 

Open up your Access database and select the "Database Tools" tab

Select the "Linked Table Manager"

MSAccessLinkODBC01.png

 

Select (tick) the tables you want to link to the new connection

When ready press OK

 

MSAccessLinkODBC02.png

 

Select the new data source you want to link to and press OK

 

MSAccessLinkODBC03.png

 

Now Enter in your credentials and press OK

 

MSAccessLinkODBC04.png

 

 

Note: the tables you select must exist at the new destination. The system works through the list of table that you tick and if it finds one that cannot be located via the new connection then it will just stop. 

You will then have to untick that missing table and press OK to proceed with the rest of them

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

This entire document, including design, text, videos,graphics, and photographs are Copyright © 2014 Austlink Plus Pty Ltd, All Rights Reserved.
No part of this document may be reproduced in any way or by any means for commercial or any other purposes, without prior written permission of Austlink Plus Pty Ltd. Use of any data for the purpose of creating promotional materials or producing a printed or electronic catalog of any kind is expressly forbidden without prior written permission of Austlink Plus Pty Ltd.

Powered by Zendesk