Read Only

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
Steve said:
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?
Click to expand...


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 said:
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.
Click to expand...


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

TC
 
Back
Top