Connection Strings (ODBC)

[ewong1]

I currently have my database set up with links to an ODBC Data Source. Is it possible to write a connection string to link the table without requiring that the user have an odbc data source set up? Thanks for your input!

 

[Summerwind]

I think the answer is Yes and No

If you hard code a connection string with a valid login to the ODBC source included, it doesn't matter who the user is because the security system will see the connection as being from a valid user.

 

[ewong1]

Thanks for getting back to me! Is there a place online for me to check out some sample code? I would like to hard code it into the db so that my users are all able to use it. Thanks!

 

[Summerwind]

The Microsoft site may well have some samples. There is also a sample in Access help. If you can't find anything, come back to me and I will post a connection string I use.

 

[jamesmor]

connection strings

all the connection strings you could ever want.

http://www.connectionstrings.com/