By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,916 Members | 1,286 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,916 IT Pros & Developers. It's quick & easy.

Linked table automatic login to SQL Server

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.