Clarification about splitting a database: what can and can't FE users change?

[marinelizard]

I'm preparing to split a database accessed by several users on a network. After perusing several excellent threads about splitting a database and using the front-end and back-end, I'm confused on what can and can't be manipulated in local FE by users. Some threads indicate that FE users will not be able to create their own queries, just use forms to input data or create reports. Other threads indicate that the BE protects the data in the tables and that each user with their local copy can create their own queries, etc.

I would like my users to be able to create their own queries since they often have last-minute tasks requiring them to extract data from tables, but I would like to keep the data safe in a back-end, accessed only by me. How do I achieve this goal (specific steps or things to keep or not keep in FE, BE, respectively)?

I've also seen threads that provide vb script that will launch the FE database each time, making changes to the FE easy to manage.

https://www.accessforums.net/code-re...life-7572.html



Can I keep the flexibility I described above while also maintaining something like a script-launched FE?

[June7]

You can allow users to create queries in the frontend but since every user should have their own copy of frontend on their local workstation, every time you distribute a new version of the frontend, their personalized work will be lost.

[CJ_London]

I

would like my users to be able to create their own queries since they often have last-minute tasks requiring them to extract data from tables,

but I would like to keep the data safe in a back-end, accessed only by me

these two requirements are incompatible. If you allow users to write queries, they can write queries to change/add/delete data. Assuming you are linking, they can also open the linked table and change data that way as well. What will be protected is your table design.

Some threads indicate that FE users will not be able to create their own queries

they can if you let them

, just use forms to input data or create reports.

this is what is recommended