Mohamadi
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
Regards
David
points to me
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