Re: How many workstations are connected to Access DB?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Phil Hunt (phung_at_ktintl.com)
Date: 02/05/04 

Date: Thu, 5 Feb 2004 09:23:04 -0500

In other word, compact it anyway, if it fails, it fails.

"PierreCampe" <Pierre.Campe@pandora.be> wrote in message
news:%23F%23$Yj96DHA.2996@tk2msftngp13.phx.gbl...
> >I'd like to run DBEngine.CompactDatabase when the
> >last user closing VB application.
> if the VB application is closing you close the database(i suppose)
> if after closing the database you open it for exclusive access, and if
that
> succeeds then you are the only user of that db, and hence the last
>
>
> "Vlad" <vovan.c@verizon.net> wrote in message
> news:OdoIuvy6DHA.4012@tk2msftngp13.phx.gbl...
> > Is there any way to find out how many users are connected to Access 2000
> > (DAO) from VB6 program. I'd like to run DBEngine.CompactDatabase when
the
> > last user closing VB application. If there is at least one more user I
> would
> > prefer even not to call CompactDatabase method.
> > Thank you
> > Vlad
> >
> >
>
>

Relevant Pages