Automated Access launch causing Access window to fail to hide

[home70]

Hi,
I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my
main switchboard to hide the grey Access screen from being visible behind
forms, reports, etc in this db. But when I started using a .vbs script file
to launch the db, the Access window stopped being hidden. (The reason I use
the script for launching is that it temporarily sets the db's security level
to 1 which stops the macro security warning from coming up.) Apparently MS
knows about this happening and released a technique to rectify the situation,
but I don't understand their instructions. It looks like they expect one to
have more understanding than I have. Could someone help me get this
impliemented? Here is the article:
http://support.microsoft.com/kb/167659/en-us
Thanks!

 

[RV]

The article you found actually does not apply to your problem.
The article applies to instances where you use Automation.
It also only applies to Access 97 and below.

I'd say that your script bypasses your switchboard hence the code in your event hence your window will not be hidden.

Can't help you with any suggestions.
Perhaps somebody else can.

RV

 

[home70]

Thanks RV, but I think you might be mistaken about my situation. I use Automation to launch the database programmatically -- with this .vbs script:

dim o
set o=createobject ("Access.Application")
o.automationsecurity=1 ' low.
rem o.opencurrentdatabase "C:\Documents and Settings\A\My Documents\test.mdb"

Launching the db programmatically and having the Access window fail to hide is exactly what this article applies to. I know that it says it only applies to Access 97 but I've used fixes before that said that they didn't apply to my sw version but the fix still worked.

What do you mean the script bypasses my switchboard? It opens to the switchboard but the grey Access screen fails to hide like it should.
In any case if someone can help me try this fix I can try it on a test copy of the db.