CODEWITHSUNDEEP
ms-access-2007
Scott Warren
Scott Warren

Reputation: 1601

How can I stop user being able to stop design view on a query in Ms Access 2007?

I am about to release some reports in Access 2007 and I need to lock down the Queries so that no one can change the queries does any one know how I can do this in Access 2007?

Please Note: Simply adding a GUI and hiding the "database window" is not enough as people can still get in with the right key stroke etc.

Upvotes: 1

Views: 3447

Answers (2)

LFurness
LFurness

Reputation: 669

In Access, if you click the Windows button and then Access Options, then Current Database, you will see options to disable navigation and keyboard shortcuts.

Upvotes: 0

Robert Harvey
Robert Harvey

Reputation: 180858

You could Make an .ACCDE, and give that to your users to execute.

You can create an .accde file from an .accdb file by clicking Database Tools on the Office Fluent Ribbon, and then clicking Make ACCDE. When you create an .accde file, Access compiles all the code in the database and strips the editable version of the code from the new .accde file. This process both reduces the size of the resulting database and guarantees that no one can change the original source code. When you open an .accde file in Access, the form and report designers and the Visual Basic Editor are not available. In addition, you cannot transfer forms, reports, and modules to another database by export or import.

However, since an ACCDE is apparently less secure than its predecessor the MDE, your best bet might be to convert the database to Access 2003 format by using the Save As command, and making an MDE from that. If you open an older .mdb file in Access 2007, a Make MDE command appears on the Database Tools tab instead of the Make ACCDE command that appears when you are working in an Access 2007 database.

Upvotes: 1

Related Questions