How to add a user login form?

[lookingforK]

Hi,

I am making a data entry form application for some users.

I want to add a user login form when opening the MS Access 2007 database. No password needed.

So, after the application is done, it can be used like that:
1. Give the accdb file to the 1st user. The user can use the login form to find his/her records in a main form (that is bound to a main table used to collect data), and then modify existing records or add new records at the end of the main form.
2. Give the accdb file to the 2nd user. The user can use the login form to find his/her records, and then modify existing records or add new records.
3. ... (next user)

How should I do?

Thank you in advance.

 

[GinaWhipp]

From your description I would split that database so no User ha to wait to be sent the database before logging in, just seems like the hard way to do things. For information on splitting...

http://www.members.shaw.ca/AlbertKallal/Articles/split/
http://allenbrowne.com/ser-01.html

You may also want to take a look at MVP Tom Wickerath's article...
http://www.accessmvp.com:80/TWickerath/articles/multiuser.htm

To handle the update of multiple front ends see...
http://www.autofeupdater.com/

If each user needs Access you can install the Runtime...
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en


While I understand you want no passwords, login forms are usually designed with passwords. This one...

http://www.access-diva.com/f7.html

...should be easy enough to modify. OR you can use the Network ID to control what data is visible to that User by having a field for Network ID in your tables. No log in required, all they have to do is open the database on their machine. You can use...

GetUserID = Environ("Username")

...to get the Users Network ID. A little code to make that field hold their Network ID and now when they enter records it's *coded* to them and when they open they will see their records. NOTE: None of this is a guarantee they won't won't open the tables and see other Users records. So, if you are looking for that type of security, this is not it.

 

[lookingforK]

Thank you GinaWhipp.