Reading with ADO from Access database over network
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Date: Mon, 29 Mar 2004 22:45:22 -0800
Hi everybody !
I made an Excel sheet 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
Relevant Pages
- Re: What is access databases login name?
... It is not the database password in Access, but rather you have to be a ... of a workgroup: this involves creating a workgroup security file in access, ... > i set the password within access, and input the password to ADO connection ... > also the ADO connection string needs login name, so i wonder if the login ...
(borland.public.delphi.database.ado) - Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access) - Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access) - Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access) - Re: Is ADO Dead (3)?
... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
(comp.databases.ms-access) |
|
