Re: set database password when converting AC00 to AC07

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Reading that db option only tells you what the setting is, not whether the db
was opened exclusively. If the locking file is already open when you try to
open the db exclusively, the db will open in shared mode, no matter what your
settings are.

To guarantee opening in exclusive mode use a shortcut with the /excl switch.

"path to msaccess.exe" "path to db.accdb" /excl

After you open the db exclusively with the shortcut, change your password.

Chris
Microsoft MVP


Stanley L. wrote:

I have verified exclusive mode in the
immediate window by getting a value of 1 when asking Open Mode =
Application.GetOption("Default Open Mode for Databases"). Also the AC07
options this database are set to open in exclusive mode.

Why won't AC2007 allow the setting of a DB password but instead tells me to
open the DB in exclusive mode when it alresdy is open in that mode?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200810/1

.

Relevant Pages

  • Re: Lost ability to login to secure database
    ... > to login and cannot open any of my secured databases. ... I assume you know the workgroup file that was used to secure your ... Create a desktop shortcut to open them. ...
    (microsoft.public.access.security)
  • Re: Lost ability to login to secure database
    ... "Joan Wild" wrote: ... >> to login and cannot open any of my secured databases. ... >> secure Access databases. ... Create a desktop shortcut to open them. ...
    (microsoft.public.access.security)
  • Re: 1 table - 2 forms
    ... The customer cannot split the columns in the table into two tables. ... Horizontal Databases are not databases. ... use good database design we have a good chance of meeting them well. ... Scientific Reading is a Scientific Reading. ...
    (comp.databases.ms-access)
  • Re: Front End Security
    ... the reading on this topic, I had the impression that this wasn't possible. ... But you don't want it to affect all mdb files. ... you can just copy the shortcut to them ... I can successfully open my FE database which is located on my local ...
    (microsoft.public.access.security)
  • Re: Creating a secure database on a network
    ... > As for the shortcut, right now I have a shortcut on their desktops pointing ... I was going to have the workgroup ... any of your other users decides to create *any* new databases or open ... do I put all the syntax for the shortcut in the target field? ...
    (microsoft.public.access.security)