It may be impossible
It may be impossible to do this, so I found another way around it.
In the form I can specify recordset type as "snapshot" instaed of "dynaset". This makes it possible to open forms in the two MDB files simultaneously.
But the users still cannot view the table directly...
I have a simple Access database with a number of linked tables to Excel spreadsheets located in the same directory.
When I open the Access database from two networked machines, I get an error on the second machine when I try to open a form that uses the linked tables. It says that the linked...