Hello!
Please, help me solve a problem.
I has 2 databases:back-end - with tables and front-end - with forms and other objects, i.e. front-end database has linked tables with back-end database. Those databases located on different computers. So linking tables was made using network path.
When I try to run code from front-end database:
Dim db As Database
Dim rs As Recordset
Set db = DBEngine.Workspaces(0).OpenDatabase("\\CompName\....\BackEndDataBase.accdb")
Set rs=db.OpenRecordset("TableName",dbOpenTable)
error occurs :"The Microsoft Jet database engine cannot open the file .... It is already opened exclusively by another user, or you need permission to view its data ".
When i do this on same computer, i.e. used local path for tables linking- all works well!!!
I need to open table-type Recordset, dynaset - not suitable.
How can i do that?
Thanks.
Please, help me solve a problem.
I has 2 databases:back-end - with tables and front-end - with forms and other objects, i.e. front-end database has linked tables with back-end database. Those databases located on different computers. So linking tables was made using network path.
When I try to run code from front-end database:
Dim db As Database
Dim rs As Recordset
Set db = DBEngine.Workspaces(0).OpenDatabase("\\CompName\....\BackEndDataBase.accdb")
Set rs=db.OpenRecordset("TableName",dbOpenTable)
error occurs :"The Microsoft Jet database engine cannot open the file .... It is already opened exclusively by another user, or you need permission to view its data ".
When i do this on same computer, i.e. used local path for tables linking- all works well!!!
I need to open table-type Recordset, dynaset - not suitable.
How can i do that?
Thanks.
