Set up users and password

[Niroth]

Hi,

I'm new to Access, and I wonder if you wonderful people can explain what are some of the ways I can create users and password for my database. Is there anyway I can prevent people from copying the database from a computer and use it on another computer? And lastly how do I create a front end and back end software? I know I sound completely ignorant, but I haven't a chance to buy a book on Access right now (not coming from an English speaking country) and I can't seem to find the right material on it on the web. I would really appreciate it if you could take the time to explain some of these things from your experience.

Niroth.

 

[Dennisk]

Search the forum for security. you will find many many post/articles on the subject.
You cannot prevent people from copying files but if the db is workgroup protected then in order to open the file not only will the workgroup will be required but also a user name and password, otherwise if someone double-clicks the protected file they will receive the following message

' you do not have permsiion to use this file'

 

[Niroth]

Thank you for the pointers.

 

[Banana]

I want to point out that if you are concerned with someone stealing a copy of database, and is dedicated enough, workgroup security will does nothing to stop them from using a low level editor to read the data within.

You could encrypt the database, but that also can be broken with enough efforts.

I'd want to place it in a place where the access is limited to a select few users. (using Windows security). Of course, they all will need full read/write permissions for that folder for the database to work properly, but as long it's just who *actually* needs the access, it's much more secure than hoping nobody is smart enough to use the beforementioned tools to bypass the security.

 

[Niroth]

I'm making it for a point of sale, so I'm concerned about the people who need to use it might fiddle with the data. But I've been reading more on user and group permission and it might answer what I need.

I couldn't understand it before when I came across it in articles because it turns out Access 2007 doesn't support it when it's saved in the new .accdb file format. Thought it needed tones of codes.

BTW, does anyone here know a quick code to record the user when they update a record?

 

[Dennisk]

assuming you have a 'LastModBy' field in the underlying table.
Place this code in the forms Before Update Event

me!LastModBy=CurrentUser()