January 5, 2011 at 5:08 am
Looks like MS Access security has a lot of workarounds and issues.
For example, I have two databases (a front-end and a back-end linked to the front-end). I wanted to secure both of them. For example setting password (this is database password and not .mdw) to back-end (BE) blocks the starting up of front-end (FE) database. Joining .mdw in both the databases (FE and BE) also doesn’t work which means it causes other databases to also prompt for credentials. So a combination of setting password to front-end and joining back-end to secure .mdw has worked. Now the databases are secure and can be opened by credentials (.mdw creds for back-end and .mdw creds + database password for front-end).
Does someone have an idea why this happens?
January 31, 2011 at 7:03 am
It is Microsoft Access...Try MS Access project... A lot safer!
February 1, 2011 at 1:04 am
Plus this type of security isn't natively supported in Access 2007/2010 but only for backward compatibility.
February 1, 2011 at 1:08 am
Once you started the project you can make use of SQL to link the DB to an access front end. It will make your life so much easier!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply