logging users against an update

[James123]

I am new to access and have created a simple log in form that looks up a
password
A user enters in a password list. I now need to link this table to my main
datatable.

So when a user updates a record it stamps their unique login against the
record. I don’t want to upsize to sql. Can this be done? If so any help would
be great.

I can then see how many records a user has updated Dailey?


Thanks

James

 

[Keith]

I am new to access and have created a simple log in form that looks up a
password
A user enters in a password list. I now need to link this table to my main
datatable.

So when a user updates a record it stamps their unique login against the
record. I don't want to upsize to sql. Can this be done? If so any help
would
be great.

I can then see how many records a user has updated Dailey?

You're rolling your own where you can get this for free with Access. See
the help for the "CurrentUser" function. It would mean setting up
user-level security which is an uphill task but I think it would pay
dividends against the admin nightmare you might end up with using a
home-grown variant.

Regards,
Keith.
www.keithwilby.com

 

[James123]

Thanks Keith, I think ive cracked it but means I rely on a user entering a
unique number when saving. Trying to get around this. If not ill look into
the built in function.

Thanks again

James