Re: Howto findout Ado not connected


Hi there,

I like to know if it is possible to find out if there is someone connected
to an Acces database.
I have a few users on an Acces database. When i want to compact and repair
the database then everyone has to be disconnected.

( Delphi 7 & ADO & Acces )

This code should give you a list of users connected to your Access Database into
the dataset specified here as AdoDataset1

AdoConnection1.OpenSchema(siProviderSpecific,emptyParam,'{947bb102-5d43-11d1-bdbf-00c04fb92675}',
AdoDataset1);
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Howto findout Ado not connected
    ... I have a few users on an Acces database. ... the dataset specified here as AdoDataset1 ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Other User Connected to ADO MSAccess Table?
    ... not in an ADOConnection Win32 application? ... When you run it AdoDataset1 should be populated with one record for each user ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)