CAN 1 access application/mdb test to see if another mdb is open??? iow: can BE tell if FE is running

[bobg]

running access2k, FE/BE config;

I would like my startup form in the BE be able to determine if the FE is running.

is there an easy way to do this?

I know I could:
set fe=getobject, or workspace.opendatabase bla bla bla...

BUT - each of these will OPEN the mdb if it wasn't already open -
I want to know if it's open FIRST!

tia - Bob

 

[Rick B]

I think you could test to see if an ldb file exists in a particular
directory, but I don't know the exact format to do so.

My question is why do you have a startup form in your back end? The
back-end should only contain tables. The forms and such should live in the
front-end.

Rick B


running access2k, FE/BE config;

I would like my startup form in the BE be able to determine if the FE is
running.

is there an easy way to do this?

I know I could:
set fe=getobject, or workspace.opendatabase bla bla bla...

BUT - each of these will OPEN the mdb if it wasn't already open -
I want to know if it's open FIRST!

tia - Bob