Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting 2 ACCESS databases

Status
Not open for further replies.

ewout1

Programmer
Nov 14, 2002
1
NL
Hey all,

I am new into this supject,I think it is an easy question.
I would like to connect two ACCESS databases.How could I realize this??? I know I must use ODBC, by the way I am using Windows 2K. Within 2K there is a ODBC-manager to handle this.How must I set the DSN!!!
For example a table of Database A combines with a table of Database B into one same table of Database B.
Thank you for helping.

Greetz,

Ewout
 
From file menu

File>Get External Data>Link tables....follow the prompts from there, watch for check boxes that will declare the link as read only!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top