I have an accdb database which is being accessed via frontend in a networked environment.
Users have access to the networked folder (read and write: full access)
when they try accessing the database via the fromend, they get the error code # 3051: need permission to access or DB is locked for exclusive use.
Code:
Dim db as dao.database
dim rs as dao.recordset
dbpath="\\10.111.65.198\project\data.accdb"
set db=opendatabase(dbpath) <<this is where the error # 3051 is reported>>
Please assist
Users have access to the networked folder (read and write: full access)
when they try accessing the database via the fromend, they get the error code # 3051: need permission to access or DB is locked for exclusive use.
Code:
Dim db as dao.database
dim rs as dao.recordset
dbpath="\\10.111.65.198\project\data.accdb"
set db=opendatabase(dbpath) <<this is where the error # 3051 is reported>>
Please assist