Is there a way to pass an Access Database password through VBA code?
Posted on 2006-11-27
I have a specific need to lock down an Access front-end so that users cannot use another (secondary) access database to "Import" the tables and queries.
While a database password will satisfy that need, it also creates another issue: I do not want users to have to enter (or know) the database password. Is there a way to pass the password internally, hardcoded in the VBA when the front-end opens (a command-line parameter call when opening the db will not work in this situation either)?