Read Only

[Steve]

Good day all,

Does anyone have a real easy way to make a front end
database file read only. The front end file is linked to
a back end database. The back end needs to continue
continue to be written to, but I do not want the users to
be able to write through this front end.

Any help?

Thanks,

Steve

 

[TC]

Good day all,

Does anyone have a real easy way to make a front end
database file read only. The front end file is linked to
a back end database. The back end needs to continue
continue to be written to, but I do not want the users to
be able to write through this front end.

Any help?

You need to:
1. implement user-level security;
2. give the users *no access* to the FE tables, and
3. do all BE access to the tables using so-called "Run With Owner
Permission" (RWOP) queries.

Read-up on RWOP queries &/or search for that term in access newsgroups.

HTH,
TC

 

[TC]

You need to:
1. implement user-level security;
2. give the users *no access* to the FE tables, and
3. do all BE access to the tables using so-called "Run With Owner
Permission" (RWOP) queries.

P.S.: none of which is "real easy", unfortunately ...

TC