Open Access without executing

[Lascar]

How can I open an Access application without executing it? What I mean is opening it the same way than when you select an Access file & open it by doing SHIFT+ENTER

 

[Joe46]

If I understand what you mean then just hold down the SHIFT key before you open it.

 

[Lascar]

I want to open it that way but through VB6. Can anyone help?

 

[BiggerBrother]

use the shell command, and then set the openning state, so
shell(myapp,WindowState), where o is normal, 1 is minimised and 2 is maximised.

BB

 

[Lascar]

It's not the window I want minimised. In an Access file, you can have a form load on startup (Tools-Startup). If you press SHIFT+ENTER on an selected Access file, the form doesn't load. I want to do the same thing but through VB, open a Access file without anything loading on startup

 

[ClulessChris]

Lascar,

Do you want to show the user the native MS Access application? or do you want to access the data/object(s) held in MS Access?

 

[Lascar]

It's hard to explain, but this is what I want to do:

Let's say you're in folder C:\temp & in that folder you have the file db1.mdb. When you select db1.mdb & press ENTER, Access opens & the form frm1 is launch on startup. But if you select db1.mdb & press SHIFT+ENTER, Access opens but doesn't launch frm1, it launches the database window (the one you bring to the front with F11). That's what I want to do with VB when I open a database.

 

[ClulessChris]

Lascar,
So you wish to show the user the database window using the native Access application?
I've not tried it out but I would guess something like:

Dim dbDbase as object
Set dbDbase = CreateObject(filepath)

dbDbase.show

Good Luck

Everybody is Somebodys nutter

 

[Lascar]

My variable is an application object. Can it work with that?