Connect to an access database in a remote directory using dao (VB6)

Question

I need to replace this structure:

dim base as dao.database
set base = opendatabase ("c:\path\name.mdb")

with another in which the .mdb is located in a server directory. I tried:

dim base as dao.database
set base = opendatabase ("\\server\folder\name.mdb")

but it did not work. I'm using VB6. Any ideas?

Answer 1

Try

set base = opendatabase ("\\server\folder\name.mdb")

Answer 2

Should we assume your code worked with "c:\path\name.mdb"?

If so, check your permissions on the file share. Opening "\server\folder\name.mdb" will create an Access lock file, "\server\folder\name.ldb" If you lack permission to create the lock file, the database won't open. Can you open "\server\folder\name.mdb" with Access?

If that's not the answer please give more to work with. Error messages?