Access Security

Good morning, I have a security set up on my Access database.  Currently, I am the only one who adds, deletes or makes changes to the user profiles on the security.  I am wondering how you guys are doing to add, delete or make changes to the ...

I see several posts on how to password protect visual basic code in Excel, but I need to protect my code in Access. Is it possible to protect the entire project with one single password that would prevent anyone from modifying my ...

I have a database that will be stored on a network where folks from around the country will do essentially data entry. They need to be able to add new records, update existing ones, and run reports. They must not be allowed to ...

Is there a way to give Users the ability to add new records to the database, but at the same time prevent them from taking any copies of the tables from it, by importing into other databases??? Thanks in advance. ...

We have an access front end that is connecting to a SQL backend. Th backend is currently using domain authentication and that is working fine. What we want to implement is to use domain authentication to open the access app. Right now we are using the built in user security, but we ...

I was trying to keep from other users to mess with the toolbar so on the Setup or StartUp, I must have disabled features.  Now I can't access View or Setup (from Tools), etc.  How can I edit these StartUp settings?  Thanks. ...

Here is my scenario: Jane and Dan share a computer. Jane logs into the Access database using her password. She leaves her desk and Dan uses the database to mark that he did a certain task. However, since Jane is logged in, the records indicate that ...

I have a secured, split database.  Works fine on my computer.  I have Admin permissions both with Access DB and with Windows. Took the database to the user.  Same setup.  User has "PowerUser" permissions.  Got a "cannot lock file" error message.   Only when the ...

Hello I've been using these newsgroups for some time and find them to be an invaluable source of information and advice. But now I have a specific problem that I cannot find an answer to; perhaps someone could point ...

Is it possible to lock a field forever? So that no-one can modify it - Even if they have Admin rights? I would like to store some DOBS and National Insurance numbers which NEVER CHANGE, unlike Surname etc. I would like to build a system, that once a DOB has been confirmed three ...

Hi, I'm building an access application, which tracks IT Labs at the local college. It will be placed on a shared drive, where students have read-only access and staff have read and write access. The system uses a piece of code ( Username = (environ("Username")) to work ...