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
 
Back
Top