MS Access Security

[LuckieIrie]

I have database setup to do timesheet reporting, work fine, however, I would like to have it open up the form designated in MS Access User Accounts for the user that is logged in.

 

[JeremyNYC]

You're not saying you have one form for each user, are you? Much better would be to check who the user is and change the form (recordsource, whatever) based on that information. In any case, CurrentUser() will return the username of the person logged in.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[JTregear]

Luckire

Please see the following thread.

http://www.tek-tips.com/viewthread.cfm?SQID=442005&SPID=702&newpid=702&page=1

It gives details about how to secure Access Databases. It also includes references to external sites which show you how to look-up a the user ID of someone using the Access database.

JTregear

 

[JeremyNYC]

Oh, jeez, not that thread, please. If you read the whole thing carefully (which would take you HOURS), you will see that the person who put out the system for doing your own security eventually states that this is the wrong way to approach the problem. There is security built in to Access, and if you're going to secure an Access database, that is what you should use.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.