I have been writing a number of relatively simple databases in MS Access for a number of years, and had been using Version 2. I am now using Access 97 and tried to tackle a problem which I could not resolve in the earlier version, but still found nosolution.
My problem is trying to secure the databases with passwords, so that I can restrict access to data (read only etc.), or stop users mucking up form designs and the like. The databases are not being accessed via a LAN, but on a stand alone machine by a only one or two users. Several separate offices use the DB in a similar way, each with their own unique set of data.
I get the passwords to work okay, but then the passwords are automatically applied to all Access DBs on that machine. Also, when I copy the DB.mdb file onto their machine (or send it to them) the DB is no longer password protected. I understand that the PW profiles are contained in C:\windows\system\system.mdw, but even if I personally install the DB on their machine WITH that file too, they only need to get another copy of an original system.mdw file and the protection is removed.
Question:
Is there some way I can compile/package/write the protection into the actual DB.mdb file (presumably without the requirement to access the system.mdw file) so that I can send just the DB to them, and the protection works without upsetting any other DBs they might have on their machine?