openning access.application skiping autoexec macro

[richi]

hi
has anyone hoe to open an access database from an access
application avoiding the execution of the autoexec macro
in the new database or the initial form in the initial
settings?

dim bd as new access.application

Bd.OpenCurrentDatabase DBName

and here executes the autoexec macro in dbname and wait
until finish the macro.

 

[solex]

Richi,

You may be able to if you are holding down the shift key when executing this
command, but I am not 100% sure. Not sure if this is applicable to your
problem but have you considered removing the autoexec macro completely from
your database and placing it in your application.

Dan

 

[Tim Ferguson]

dim bd as new access.application

Bd.OpenCurrentDatabase DBName

and here executes the autoexec macro in dbname and wait
until finish the macro.

Well, whoever developed DBName clearly has a need for certain code to run
before the User Interface is made visible... so it's not very nice to try
to open it in a subverted manner.

I have to wonder, though, about whether you really need to open the
application anyway. If you want to get at the forms and projects, simply
import them into the first database. If you want to get at the data, just
open it as a Database object and then run queries against it as normal.

Hope that helps


Tim F