openning access.application skiping autoexec macro

  • Thread starter Thread starter richi
  • Start date Start date
R

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.
 
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
 
dim bd as new access.application

Bd.OpenCurrentDatabase DBName

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

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
 
Back
Top