ACC2000: Cannot Check to See If Database Was Opened Exclusively (210592)
The information in this article applies to:
This article was previously published under Q210592 Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
In a multiuser environment, you cannot use the OpenDatabase method to find out if the current database was opened exclusively. If you try to open the current database with the OpenDatabase method in Visual Basic for Applications and the current database was originally opened exclusively, the database opens and no error is returned.
CAUSE
Microsoft Access ignores the option flags for all opens except the first
for a specified window's task, so a system administrator cannot use this technique to test whether a database has been opened exclusively. The technique does not work because Access does not check the option flags.
REFERENCESFor more information about the OpenDatabase method, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type OpenDatabase method in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 12/12/2002 |
---|
Keywords: | kbdta kbprb kbProgramming KbVBA KB210592 |
---|
|