Linking to SQL

[NeoPa]

I'm afraid we use System DSNs set up on each machine.

[Nitro]

I'm afraid we use System DSNs set up on each machine.

So you go t every User's Machine and setup a System DSN? Isn't that a hassle?

[NeoPa]

It's part of the PC build instructions.
Only users who use the ODBC links have it enabled.
We only have 50-60 users in the office.
BTW - I wasn't suggesting it as a solution for you - that would be stupid, as I don't know enough about your environment and what you're trying to achieve.