How to connect to a BE database? (1 Viewer)

[MarvinM]

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.

 

[spikepl]

I understand that I need to open the BE tables directly in order to do this.

Incorrect. Look up and read very carefully the documentation of .Seek.

 

[Mihail]

This thread will show you more than you answered.

 

[MarvinM]

Thanks Spike & Mihail,

I got this resolved. I had 2 problems.
1) I was able to set the UNC path in the Linked Table Manager.
2) .Seek is for use with local tables, not linked tables. I had to use .FindFirst instead.

Thank you!