Connect User id to data entry

[kkbharat]

Hi everybody,



I am new to Access 2010 and would like ask as to how I can connect user id to entries made in the database/tables to particular user who has say logged in the system. I have seen many youtube videos but they dealt with how to create user login form.

I would like to know how once a user is logged in, all the entries made by him should be related to this particular user and if somebody else login then the entry made by another user in the same table should be related to the another user.

Also can anyone tell me how to set Tempvar variable as a default value in a table.

Can anyone please guide me.

Thanks

Bharat

[June7]

Can grab the user's Windows username with: Environ("USERNAME"). No log in form needed. Can save that to record. Or use it to lookup user info in a Users table.

I set a textbox with user ID on a form that never closes (MainMenu). Then VBA code saves the ID to record.

[kkbharat]

Thanks for your reply.

I have only few users and the method suggested by you is little complex. Is there any simpler way?

Thanks

Bharat

Can grab the user's Windows username with: Environ("USERNAME"). No log in form needed. Can save that to record. Or use it to lookup user info in a Users table.

I set a textbox with user ID on a form that never closes (MainMenu). Then VBA code saves the ID to record.

[isladogs]

That is the simplest way.
Also bear in mind that if person A uses your database on a computer where person B is logged into the network, all data changes will be logged to person B.
This is going to be an issue if users share workstations.
To prevent that issue, you use a separate login to your db with it's own login form.

[June7]

Even a login form won't necessarily resolve that issue. If User A logs in and leaves db open and User B continues with the already open db (before Windows can lock the computer), User A will continue to be assigned to records. Code can do only so much. Users have to follow procedures. Log off when no longer working with db.

[isladogs]

True. One solution is to forcibly log people out of the db after a set period of inactivity.
But no system is totally foolproof

[orange]

Bharat,

You have been given advice regarding your specific question. I note that you have 9 posts here and your post is concerning multiple users modifying the database and your wish to know who modified which record. You are asking about userIds, individual logins and a record of who did what.
My question to you concerns database design since userids and logins will only work smoothly if your design matches your requirements and is implemented following database practices. What is your database about in simple terms? Can you tell us more about the business this database is intended to support?

You may have seen these videos by Steve Bishop re user logins and managing user access to your data.
https://www.youtube.com/watch?v=YQmy5tLn0kw
https://www.youtube.com/watch?v=DxRpo496w_c
https://www.youtube.com/watch?v=356ylQn6kkA

Good luck with your project.

[kkbharat]

Hi Everyone,

Thank you very much for your kind response.

I shall try watching videos by Steve Bishop as suggested by Orange (Moderator) and then if I have any questions I shall come back.

Thanks everyone once again.

Regards, Bharat