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,

Answers


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


Need Your Help

Is there a css selector based on whether an element has a particular property?

css magento css-selectors

I am working with Magento which doesn't allow for classes on images in the visual editor; so I want to program it to automatically apply right margin to an image if the image has the property float...

Generate dynamic list from external database

sharepoint-2007 wss-3.0

I'm very new to Sharepoint and I am just wondering if it's possible to somehow use data from an external database as a List that users can select from within a form. How much extra development does...