By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,497 Members | 2,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,497 IT Pros & Developers. It's quick & easy.

ODBC Connection to Multiple Access Databases

P: n/a
TS
Does anyone have any experience creating an ODBC Connection to multiple
Access databases?

I need to be able to connect several databases, rather than linking to the
tables.

My only experience with ODBC is connecting to Progress databases. Progress
uses parameter files where you can specify any number of databases with the
one DSN. Referencing the data is [logical database name].[table
name].[field name], although you can omit the database if the tables are
unique.

TIA
Ken
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can't use ODBC to connect from an Access database to another Access
database.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"TS" <tw*******@yahoo.co.ku> wrote in message
news:%Y*****************@newsfep2-win.server.ntli.net...
Does anyone have any experience creating an ODBC Connection to multiple
Access databases?

I need to be able to connect several databases, rather than linking to the
tables.

My only experience with ODBC is connecting to Progress databases. Progress
uses parameter files where you can specify any number of databases with the one DSN. Referencing the data is [logical database name].[table
name].[field name], although you can omit the database if the tables are
unique.

TIA
Ken

Nov 12 '05 #2

P: n/a
Can help with ODBC to MySQL, MS SQL, PostgreSQL.
You can open more than 1 database by VBA

illya

"TS" <tw*******@yahoo.co.ku> wrote in message
news:%Y*****************@newsfep2-win.server.ntli.net...
Does anyone have any experience creating an ODBC Connection to multiple
Access databases?

I need to be able to connect several databases, rather than linking to the
tables.

My only experience with ODBC is connecting to Progress databases. Progress
uses parameter files where you can specify any number of databases with the one DSN. Referencing the data is [logical database name].[table
name].[field name], although you can omit the database if the tables are
unique.

TIA
Ken

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.