Login Form & Others

[Engr. Clement]

Pls, can any body help me to understand how to:
1. Create a login Account in Access with the following properties: (a) UserName, (b) Password, (c) Time In (d) Time Out.
NOTE: The Time in and Time Out will not be displayed on the form rather it is for history purpose.
(e) Access level. i.e an interface where I can specify a users right on the number of tables and queries he/she can have access to.
2. How to validate an access database file for a period of time and possibly run another code to revalidate it for another period of time until over and over again. A kind of dongle stuff.
3. Use an Add/Remove button to add image to a column on the form. I mean how to code it.

[Island1]

You don’t give version(s), but here are a couple of links to hands-on procedures where they do things very similar to what you describe (among many things that may not yet have crossed your mind in this arena ...):

Here is a pretty comprehensive list of dozens of practical MS Access Forms procedures for things that developers like yourself often find themselves doing. I reference it all the time in forums, with clients, and in my own efforts of this nature. (Most of the entries make available downloadable code and other samples! Excellent template material!) The “library” of “how-to’s” here is quite impressive …

http://www.databasedev.co.uk/forms.html

Also, see these links for tips and ideas:

http://www.databasedev.co.uk/login.html

http://www.access.qbuilt.com/html/custom_login.html

Here is also another Database Journal thread regarding similar stuff, and an offer to help by a respondent:
http://forums.databasejournal.com/sh...threadid=45488

Keep us posted on your progress!

Bill

[Island1]

Did you find anything in the references I supplied to help you meet the business requirement? If they only get you part way, please advise and we can attempt to answer specifically focused questions.

Thanks, and Good Luck!

Bill