Unanswered: Remote connection to MSAccess using ADO
Using ADO I tried to connect to an Access database in remote machine
'his_machine'. The test1.mdb file shared to me with full
control in a shared folder 'shooter'. His_machine is is
When I run the VB code I got the following error.
Run-time error -2147467259 (80004005)'
The Microsoft Jet database egine cannot open the file
'\\his_Machine\shooter\test1.mdb'. It is already opened
exclusively by another user, or you need permission
to view its data.
It is not opened by anybody.
Any idea why and how to solve it? Please help..!