How to Access Query Wizard?

[NoSmoke]

I have just discovered one can "lock" (if that's the correct term) a database, such that users cannot modify it, by changing the file extension .accdb to .accdr. This works well but, I cannot figure out how to let users still get access (so to speak) to the Query Wizard. The closest macro command seems to be OpenQuery but that doesn't do what I want.

Is there another way anyone could kindly suggest?

TIA...

 

[jdraw]

Can you be a little more specific in what you fear is?

If you restrict the users to use forms, and you define any related queries and buttons etc, you can control much of the application. You should never let users have direct access to tables.

I don't think you can really stop a very determined technical user, but that isn't the common user.

Please tell us more.

 

[NoSmoke]

Yes, I would like to leave the users the capability of composing their own queries (via the Query Wizard) but keep them out of the stuff in the ribbon that can modify the database. The .accdr extension suppresses the ribbon except for File/Print & Exit but also unfortunately suppresses Create/Query Wizard.

 

[jdraw]

Perhaps there are other options. Depending om what the queries and complexity of them is, and the data these queries must deal with, you may have some flexibility.

We had an online Finance/Grants/Loans Legislation with various requirements for applying and receiving monies. We created what were known as a Point in Time (typically Month End or FiscalQuarter End) databases. These had special roll up information by several factors which were identified by the various analysts.finance officers etc. They used these Point in Time Reporting databases do identify trends, funds expended, funds identified for expending before year end, funds likely to lapse, etc, etc

The key here was the online system could changed several times a minute - numbers were not static. But by taking these various Point in Time /Reporting databases at specific times (the numbers were "frozen" in these databases and summarized appropriately).

Just soome thoughts for consideration.