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
Windows 2000.

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..!