Link to home
Start Free TrialLog in
Avatar of Mohamadi
MohamadiFlag for Iran, Islamic Republic of

asked on

Access mdb file from cd?

Hi
i want to connect to a mdb (microsoft Access database) from CD drive by ADO Connection.
but ADO create an exception(can not create lock file). i think that Access wants to create an temporary file (*.ldb) and because the main file (*.mdb) is on CD dirve it can not.
so how can i prevent ADO from creating this temp file (*.ldb) or change locatine to a place other than CD drive?
Thanks in advance
NIMA
ASKER CERTIFIED SOLUTION
Avatar of Mohammed Nasman
Mohammed Nasman
Flag of Palestine, State of image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Voodooman
Voodooman

Hi

Just a suggestion.

Create a database locally on your C: drive and either link the tables on your CD or import the tables.

Do a test by opening the mdb with MSAccess/ and /or linling the tables - this will give you some clues.


Voodooman
good idea,

if that works properly then the only differenace will be that thw file on CD is read-only ... so .'. try copying it off making it not real-only and then using it

David
I feel that I aught to get some points here, the file was almost certainly read only and so could not be accessed normaly

Regards

David
points to me