Linking a Database to Multiple ODBC databases ?

  • Thread starter Thread starter acs68
  • Start date Start date
A

acs68

Hi all,

I have a sql server 2k database that I want various apps to be able to link
to. Is it ok for multiple apps to connect a couple of ODBC sources each ?

cheers,

Adam
 
Yes, but you won't be able to make effective use of joins. While you can
still join tables from different databases you can't optimize those joins so
performance will be affected. Still, it does offer a method of using data
that would ordinarily be unavailable.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why linked sql database is read only 2
Linking to Advantage database 1
Detect failed ODBC connection when vpn is not up? 4
Connection string for passthrough query on windows 7 64 bit??? 18
ODBC Update on a linked table 'table name' failed 1
Can't connect to ODBC database 3
split database 1
How to create DSN-Less Connection to AS400 1

Back
Top