Microsoft KB Archive/208797

= ACC2000: Browser Link Opens Multiple Instances of Microsoft Access =

Article ID: 208797

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208797



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
In a Microsoft Access database, if you have a built-in Switchboard or a custom form that contains a class module as a Startup form, and you open the database through a link from a Web page, it may open multiple instances of Access.

NOTE: This can occur in both MDB and MDE files.



CAUSE
This problem may occur if the following conditions are true:
 * The Web page is being accessed from Microsoft Internet Explorer 3.x or later.
 * The Startup form has its HasModule property set to True or the form is calling a function referencing VBA332.DLL.
 * The hyperlink is a file reference.



RESOLUTION
To work around this problem, change the link from a file reference to a URL as described in the following example.

Example
 Close all instances of Access. Move or copy the sample database Northwind.mdb to a folder on the Web server or make the current folder a virtual directory. Edit the Web page, changing the file reference to a URL. For example, change the following

Northwind

to:

Northwind

 View the Web page with Microsoft Internet Explorer and click the Northwind hyperlink.

Note that one only one instance of Access is opened.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="moreinformation_section">

Steps to Reproduce Problem
<ol> Open the sample database Northwind.mdb.</li> On the Tools menu, click Startup.</li> In the Startup dialog box, click the Display Form arrow and select the Employees form.</li> Close all instances of Access.</li> Edit a Web page, adding a file reference to the Northwind database. For example:

Northwind</a>

-or-

Northwind</a>

</li> View the Web page with Internet Explorer 3.0, 4.0, or 5.0 and click the Northwind hyperlink.

Note that multiple instances of Access are opened.</li></ol>

<div class="references_section">