Re: Reading with ADO from Access database over network

From: onedaywhen (onedaywhen_at_fmail.co.uk)
Date: 03/31/04 

Date: 31 Mar 2004 01:35:41 -0800

Is your ADO code trying to open the Connection with exclusive locks
e.g. Mode=adModeShareExclusive? If so, instead consider locking the
*data* at the row- or perhaps table-level rather than locking the
database.

If someone else if doing this (e.g. another application, a user
opening the DB in the MS Access GUI, etc), find out who it is and ask
them to stop! You may need a different security approach e.g. use
workgroups security so the database is only locked when someone with
administrator rights actually needs to do administrator-type things in
the database. 

--
"Marius" <anonymous@discussions.microsoft.com> wrote in message news:<12a3f01c41622$92dd91f0$a601280a@phx.gbl>...
> Hi everybody !
> I made an Excel *** that is reading from an Access 
> database (using ADO)) located on other computer in the 
> same workgroup.
> From time to time, when trying to open the ADO connection 
> it reports an error (no. -2147467259) saying that the 
> database is open exclusively...
> To overcome this situation my solution is to manually 
> display the source folder content using Network 
> Neighborhood - then the connection can be opened normaly, 
> without error.
> Do you have any solution to avoid such problem.
> Thanks in advance !
> Marius