Same user for mdb and Win XP

[Guest]

I have an windows XP installed recently on my PC. which has 4 users and 1
Administrator.

I have an mdb on same PC, I am going to make the same 4 users ( I mean by
the same name & Password) in the database security.

Is it possible that when I try to open the database, by default it should
collect the current users and password and get the mdb opened.

If yes, please advise me the method.

Regards.

Irshad

 

[Douglas J. Steele]

I'm not quite sure what you're asking. Are you saying that you want to
integrate the users created under Windows XP with your database?
Unfortunately, you can't: Access doesn't have the equivalent of, say,
Trusted Connection in SQL Server.

To learn how to secure an Access database, check out the FAQ at
http://support.microsoft.com/support/access/content/secfaq.asp

Read it carefully several times, work on a copy of your database, and make
sure you don't leave out any steps.

 

[Larry Linson]

... integrate the users created under Windows
XP with your database? Unfortunately, you
can't: Access doesn't have the equivalent of,
say, Trusted Connection in SQL Server.

However, if it is more a matter of controlling flow and movement between
screens, as it often is, you can obtain and use the user's Network Login for
that purpose. See http://www.mvps.org/access/api/api0008.htm for a freely
downloadable, freely usable example.

And, it is well to understand that for all its complexity and steep learning
curve, you should not rely on Access' security to protect anything that is
worth more than about $150 to you -- because that is what a "password
recovery" software package will cost them if they diligently try to find
one.

Larry Linson
Microsoft Access MVP