Connect Without ODBC - Help Pls

[hegartyjp]

Hello.

Would really appreciate some help with this.

Can anyone tell me if it is necessary to have an ODBC link set up on every PC where a user is going to access a SQL Server DB through Access.

There will be about 200 to rollout and I am praying there is some other way.

Please Help

Desperate...

Thanks in advance

 

[rjoubert]

You can look into using UDL files to store the connection string information. I'm not sure if they can be used in Access. Here's a link that explains the use of UDL files in ASP...you may be able to tweak the code a bit to make it work in Access for you.

http://aspalliance.com/434_Database_Access_Using_UDL_Files

Good Luck!