B
billharrison9
I need advice on a good way to set up a dsn-less connection. I have an
Access 2003 database that needs to connect to a SQL server. I want to:
--Automatically open the linked table in a way that the user will never
see a SQL server log-in message
--Connect without saving a DSN file on the individual computer (saving
the connection string in the db, not on a user's computer).
I don't care if the connection is established every time the db opens,
but I need it to be available when a query calls on the table.
I want to hide all the connection information inside the database, so
that
--Users won't have to worry about having a dsn-less connection file on
their computer
--Unauthorized users will have a more difficult time finding the
connection info.
The data isn't critical and the log-in is read-only, so saving the user
name and password is OK. This is not over a trusted connection... it
will use a read-only log-in assigned just for this access database.
What's the best way to set this up in my Access database?
Thanks!
Access 2003 database that needs to connect to a SQL server. I want to:
--Automatically open the linked table in a way that the user will never
see a SQL server log-in message
--Connect without saving a DSN file on the individual computer (saving
the connection string in the db, not on a user's computer).
I don't care if the connection is established every time the db opens,
but I need it to be available when a query calls on the table.
I want to hide all the connection information inside the database, so
that
--Users won't have to worry about having a dsn-less connection file on
their computer
--Unauthorized users will have a more difficult time finding the
connection info.
The data isn't critical and the log-in is read-only, so saving the user
name and password is OK. This is not over a trusted connection... it
will use a read-only log-in assigned just for this access database.
What's the best way to set this up in my Access database?
Thanks!