Linked table automatic login to SQL Server

[Lee Marsh]

Hello everyone,
I have an Access 2000 project that uses two linked tables. The tables
reside on an SQL Server machine. The SQL database requires a user login, so
when some one opens the database they are presented with a login dialog box
to make the connection. This is unnecessary security; I would prefer to
log the user in automatically as the mdb file opens, if possible. The user
login and password provide read-only access to a limited number of files, so
security isn't an issue.

Has anyone done anything like this? Any help is appreciated.

[Bernard Peek]

In message <M1********************@tornado.tampabay.rr.com> , Lee Marsh
<le*******@goodwill-suncoast.com> writes

Hello everyone,
I have an Access 2000 project that uses two linked tables. The tables
reside on an SQL Server machine. The SQL database requires a user login, so
when some one opens the database they are presented with a login dialog box
to make the connection. This is unnecessary security; I would prefer to
log the user in automatically as the mdb file opens, if possible. The user
login and password provide read-only access to a limited number of files, so
security isn't an issue.

When you create the link to an external SQL Server table you have the
option of saving the password.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.