Two instances of same database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SHIPP - 02 Feb 2006 15:29 GMT

If you have 2 instances of the same database opened is there any way to
programmatically close a specific instance. In other words how does access
identify which of the two instances you are working in? Is there a _1 and _2
put after the names such as what happens when you link to the same table
within Access or when you use the same table multiple times in a query?

Signature

M. Shipp

Reply to this Message

Alex Dybenko - 06 Feb 2006 11:24 GMT

Hi,
you can create a public variable, and assign it a unique value each time mdb
opened, for example time or guid

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> If you have 2 instances of the same database opened is there any way to
> programmatically close a specific instance. In other words how does access
> identify which of the two instances you are working in? Is there a _1 and
> _2
> put after the names such as what happens when you link to the same table
> within Access or when you use the same table multiple times in a query?

Reply to this Message