ODBC Link Tables to Two Databases...

  • Thread starter Thread starter ABAX via AccessMonster.com
  • Start date Start date
A

ABAX via AccessMonster.com

Okay - so I have two databases with the same file structure. Each of our
clients has a seperate DB. (Don't need the bad archetecture lecture, I
didn't set it up). One of the tables inside the db is 'tbl.invoices'.
Basically, I want to pull the invoice table for each client. To test - I
went into Access and set the ODBC connections for three db's for this invoice
table (and save connection password). When I go to simply view the tables,
the tables always return the data from the first linked. The data is pulling
the same across instances. Does this make sense? It appears that access is
not keeping it's connections to each client's invoice table. Any suggestions?
Thanks for your help in advance.
 
For those who I thoroughly confused by this string... I figured it out so I
will explain. The ODBC connection that I had setup was generic in that it
required you to enter database name. I selected save password but it
apparently doesn't save the database it connects to when multiple dbs are
present. To remedy, I made separate ODBC connections in the administrative
tools - ODBC connections for each of the db's with the specified db name. It
worked fine at that point. Now the only pain in the butt is setting up 40+
ODBC connections. Time to start learning VBA.
 
Back
Top