Cannot open MDB file in design view
Posted on 2006-06-06
I have an mdb file that is used by Quality Control employee's to update the data. They need to make changes to the access database. When I go to open the mdb file as they do I only have the ability to enter the data. .Various buttons and menu options are removed, such as the View and Tools menu. Also when I open the mdb I am prompted with a security warning message to open or cancel opening the file. I am suspecting that some type of a Macro is being kicked off at the start of the application.
I need to be able to open the mdb file in design mode and have the ability to access the tables with populated data. Can anyone provide suggestions as to how I can get around this. Thanks.