Microsoft KB Archive/186308

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

Article ID: 186308

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q186308





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 versions 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 Microsoft 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

Northwind

to:

Northwind

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

Note that one instance of Microsoft Access is running.

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97.

<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 Microsoft 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 Microsoft Internet Explorer and click the Northwind hyperlink.

Note that multiple instances of Microsoft Access may be opened.</li></ol>

<div class="references_section">