Linking a Database to Multiple ODBC databases ?

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
 
A

Arvin Meyer

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
 
Top