Clarification on distrubution

[Jen0dorf]

Hi



my first database is nearly done!!!

What I want to do is to cut ten copies of the database for society members to use. They do not need access to tables, forms design etc

I was going to find out how to turn off all me ribbons, menus etc ( all necessary controls are buttons on the forms) and then compile an ACCDE file and then copy that to a dvd/CD

I'm assuming that this will prevent users from editing tables and settings etc?

DO I need to split the database in this scenario?

Am I correct in this?

many thanks

Ian

[redekopp]

you may find this thread useful https://www.accessforums.net/securit...bar-39781.html

[CJ_London]

compiling to accde protects against changes to form and report design and code modules. It does not protect against changes to tables and queries

Assuming your users are sharing the data, then the db should be split and they just have a copy of the front end (queries, forms, reports, code modules) and the backend is then shared(just tables). If they are going to use it and not share data then technically the db does not need to be split - but if you subsequently need to provide updates/bug fixes etc they will lose all their data - but this may not matter if all they are doing is viewing data and not editing or changing it in any way.

note that you cannot run access from a cd/dvd so presumably the idea is your users will copy it to their own machine

They will also need a copy of access unless you are going to provide a runtime version with all that entails

[Jen0dorf]

Hi

thanks one and all.

Looks like I just need to protect the tables etc

cheers

Ian