I have 5 databases that use linked tables and wanted to password protect all 5 database. Problem is that some of the macros now are not working. I am getting a RUNCODE error and it is locking up. Did I forget to add something to the VB code?
Chances are that if a database is protected and you're running a macro that accesses a linked table from a protected database, it will have a hissy fit.
I suggest (quite a long winded)... suggestion 8-)
- remove all password protection.
- convert all macros to modules
- replace the docmd.runmacro commands to call the modules
- test them all
- if they all work, delete the macros (not the modules)
- password protect the VBA code
- convert the database to an MDE
It does all depend on why you are wanting the password protection.
Management wants to have only certain users to have access to certain databases, just because one person got into where they should not have been-----causing problems..
So, with 50 users, instead of using the Security Wizard.. etc. I figured it was easier to just do passwords. Your first response is understandable but-- a lot of work. The second one makes me wonder if that might be ALL I would have to do just to get this to work..??
Backup all the databases and then try relinking the tables using your new passwords.
Might be worth a shot but I am nt sure it will solve all your security issues.
Perhaps it's time to build your own logon form with a users table
Users(Username, Password, db1, db2, db3...)
the db fields could be a simple yes/no which you can reference to give them access to the correct databases (Eg, user1 can only access db 1 and 3 - User1, ***, Yes, No, Yes)
Or use the access wizardyness.