Search results

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...

Sorry, I forgot to say that I already did that, and it doesn't seem to affect the way Access opens up linked tables.

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...