ms Access VBA automation

[Skywalker]

hello all
I have one problem. I have lost 2 days with browsing but no possitive effect :(
Description:
I have database A - (dbA) and database B (dbB). I want from some form of dbA call procedure, which checks, other instance of MS access with dbB is running...if not, then creates new instance and opens this database. And the same also in reverese: run check from dbB if dbA is opened on current computer and if not, opens it.
I have no idea how to do this... i have spent days with AUTIMATION and access.applicat ion object and methods GetObject(),Cre ateObject...Mai n problem is, that GetObject doesn't garantee which instance it chooses(in best case it returns needed dbB from dbA or dbA from dbB)... Maibe some cooperation of API and Automation can handle this , i am not sure...Please, help me if you can...Zdeno

[debasisdas]

How instance of an Access database runs ?

[Skywalker]

Hi. Thanks for your interest..so, I will try to explain it as much as I can....This utility is needed for my job. There is one workplace in plant, where tvo different databases ase needed for operator's work - he is inserting data via barcode. So, one database is something like warehouse system, another one like maintenance database. There is no datarelation between them, there are different entities without any relation inside them...So it is solved like 2 different applications... I just want to call start or focusing of one database from the other, when operator presses for example F7 key.F7 key will be used like user's input to activate another database /maximize its mainscreen if it is running or start it if it was not started yet/. I just want to eliminate tasbar icon clicking which can be in real production in plant considered like delay of production...th is is not my idea but idea of my supervisor. I hope you understand...

[debasisdas]

There is nothing like starting an Access database.