Access 2007, split database, 9 users.
I have been able to link the BE tables with the Linked Table Manager. I use the DNS name path because everyone has different drive mappings.
I can open my linked tables as a RecordSet and AddNew and Update records. However, I cannot Seek and Edit the linked tables. I understand that I need to open the BE tables directly in order to do this. Now, I can do a connection like this, and it works for me:
Set dbs = DBEngine.OpenDatabase("\\Server\MyBackEnd\Data\Task_be.accdb")
This doesn't work. What am I doing wrong? Thanks.
I have been able to link the BE tables with the Linked Table Manager. I use the DNS name path because everyone has different drive mappings.
I can open my linked tables as a RecordSet and AddNew and Update records. However, I cannot Seek and Edit the linked tables. I understand that I need to open the BE tables directly in order to do this. Now, I can do a connection like this, and it works for me:
Dim dbs As DAO.Database
Set dbs = DBEngine.OpenDatabase("R:\Data\Task_be.accdb")
But, as I said, everyone has different drive mappings. Therefore, I need to use the Network address instead of a drive letter. I tried this:Set dbs = DBEngine.OpenDatabase("R:\Data\Task_be.accdb")
Set dbs = DBEngine.OpenDatabase("\\Server\MyBackEnd\Data\Task_be.accdb")
This doesn't work. What am I doing wrong? Thanks.