Hi All, 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,
+1
A:
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
CodeSlave
2010-09-02 15:38:54
Making an MDE/ACCDE makes the design of all code-bearing objects read-only. This means that it has no effect on tables, queries and macros, none of which are code-bearing. It locks forms, reports and modules.
David-W-Fenton
2010-09-02 18:36:38