How to connect to a BE database?

Dec 11, 2013
Reaction score
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:
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("\\Server\MyBackEnd\Data\Task_be.accdb")

This doesn't work. What am I doing wrong? Thanks.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question