Linked tables are sometimes locked MS Access VBA
I have two MS Access files (.mdb) one is called "A" and the second one is called "B". A contains the database tables and B is read only and contains reports. B also contains Tables and are linked to the tables of A. When I run a report from B, the linked tables are locked and give me nothing. Is there any solution for that? Thanks,
Further to Remous's comment, if you have set up B.mdb as read only to keep your users from changing the reports, you can accomplish the same thing by making an MDE out of B.mdb. It's effectively compiling the existing MDB and turns off editing forms, reports, etc. Data can change, and I think macros can be imported/exported - but otherwise its pretty bullet resistant.
You can do that by going to: Tools -> Database Utilities -> Make MDE