ACC2000: Logon Dialog Box Appears When Using Wizard or Add-in in ADP (198895)
The information in this article applies to:
This article was previously published under Q198895 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access project (.adp).
SYMPTOMS
If you have used Microsoft Jet database engine security to assign a password to the Admin account, and you then try using a wizard or an add-in in a Microsoft Access project (ADP) file, Microsoft Access may prompt you with a logon dialog box. After you enter the appropriate password, you are not prompted again during that session.
CAUSE
The wizards in Microsoft Access rely on the Microsoft Jet database engine, which is loaded on demand when you run a wizard or add-in. The Microsoft Jet database engine does not load by default when you open Microsoft Access 2000, unless you open a Microsoft Access database (MDB). This allows for
better performance and uses less memory when you are working only with Access project (ADP) files. Consequently, if Microsoft Jet has a
password assigned to the Admin user account, and you are working in an
Access project, you receive the logon prompt when the Microsoft Jet database engine is loaded.
RESOLUTIONWARNING: The following workaround creates a shortcut that bypasses built-in Microsoft Access security by automatically logging you in as Admin. Remember that anyone using this shortcut can open your Microsoft Access databases as Admin.
To work around this behavior, follow these steps:
- Right-click the Windows desktop, point to New on the menu that appears, and then click Shortcut.
- In the Create Shortcut wizard, type the path to MSAccess.exe. The
default location is the following:
c:\Program Files\Microsoft Office\Office\MSAccess.exe
- At the end of the path to MSAccess.exe, type the /User and /Pwd switches with Admin as the user and whatever password you use for the Admin.
For example, if Admin has the password "x" and Microsoft Access
is installed in its default location, you would type the following in
the Create Shortcut wizard:
'c:\Program Files\Microsoft Office\Office\MSAccess.exe /User Admin /Pwd
x'
- Click Next.
- On the Shortcut Name screen, type Access as Admin and click Finish.
You now have a shortcut that takes you to Microsoft Access and automatically logs you on as Admin. Now, if you run a wizard or add-in during that session, you are not prompted to log on.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Minor | Last Reviewed: | 1/26/2005 |
---|
Keywords: | kbbug KbClientServer kbpending KB198895 |
---|
|