Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why Does Access 2002 Automate in Minimized Mode?

Status
Not open for further replies.

Sue9

Programmer
Sep 5, 2002
2
0
0
US
Our VB6 application lets users run reports in a Microsoft Access database with the following code. The name of the report database is stored in “strReportDB”. The “UtROSESAccessReports” routine links the tables in the “gDBPath” database before displaying the report menu form.

Set AppAccess = CreateObject("Access.Application")
AppAccess.Visible = True
AppAccess.OpenCurrentDatabase strReportDB, True
AppAccess.run "UtROSESAccessReports", gDBPath
MsgBox "Press ENTER to continue ..."

This code works at all of our Access 2000 sites and at all but one of our Access 2002 sites.

At the problematic Access 2002 site, Microsoft Access loads in minimized mode. Therefore, the user must maximize Microsoft Access in the task bar to see the report menu. What causes this?

The user claims that Microsoft Access opens normally when he opens it manually. Supposedly, Microsoft Access is only minimized when our VB6 program automates it.

Here are some details about the problematic environment:

Computer Brand:TOSHIBA
MODEL: Satellite Pro 4300 Series
OS:WINDOWS 2000 5.00.2195
Microsoft Office Version:XP 2002 Enterprise Edition
Microsoft Access:Microsoft Access 2002 (10.3409.3501) SP-1
Printer Drivers: HP4, Adobe Acrobat Distiller, HP 4500C, Microsoft FAX
Dafault Windows Printer is HP 4

Thanks for your help!


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top