Record Edit Information

[andrewbc]

Hi

I have a form with a Tab control on it with various sub forms on each tab. Each page of the Tab box has been enable property set to no. So that users can view information with accidently changing. At the top of the page is a button "EDIT" that when clicked changes these properties to 'Yes' so that users can change information.

I now want when users click the edit button that a pop up form/box appears and they have to enter their username and password to be able to edit this informaiton. I also wish to record the username in a field against the record.

The user name info is stored in Table called 'Access' and fields 'Name' and 'Password'.The Field to store the username is Table 'Client' Field is 'Updated By'

Im have reasonable knowledge of access but if you more information please let me know.

Cheers

Andrew

 

[wiklendt]

i would look into setting up your db so that each user has to login before they can use the database, then, i'd read up on "permissions" (i'd tell you about it myself but i haven't ever used them myself, i've heard they're effective, though).

as far as i know, permissions allows you to group users into access levels - you can think of it as "admin" rights, or "user" rights and "read-only" or whatever.

if the user has permission at the time they click 'edit', then they can just go right ahead and edit, if not, you can throw up a dialog box saying something to the effect of "you do not have permission to edit these records. please see your database manager..." blah blah.