I have an secured Access database which uses Jets username and password security. Don’t want to use a database password.
However I don’t want every database to use the same system.mdw, so have to let users open from a shortcut with a command line option “/workgroup” to specify the location.
Anyone can bypass this by opening the database directly, bypassing all security.
Is there a good (or any) way to make it secure programatically or otherwise? If not then it seems that using Jet is a waste of time