I have been able to link the BE tables with the Linked Table Manager. I use the UNC 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. (I have been told this is incorrect, but can't see how. As per the Microsoft Developer Reference, "You can't use the Seek method on a linked table because you can't open linked tables as table-type Recordset objects. However, if you use the OpenDatabase method to directly open an installable ISAM (non-ODBC) database, you can use Seek on tables in that database.")
Now, I can do a connection like this, and it works for me:
Expand|Select|Wrap|Line Numbers
- Dim dbs As DAO.Database
- Set dbs = DBEngine.OpenDatabase("R:\Data\Task_be.accdb")
Expand|Select|Wrap|Line Numbers
- Set dbs = DBEngine.OpenDatabase("\\Server\MyBackEnd\Data\Task_be.accdb")