prevent import /export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to give the user permissions to alter, insert and delete data into the
tables but I don't want them to be able to export the tables or import them
from inside another database. How can I do this?
 
I did something similar to this last year. The trick is to never allow your
users to have access to the Database window nor to any table views.

First I split my app into front-end and back-end files, then I created forms
which allowed the users to add,edit and delete records. Then I implemented
Access security, then I disabled all shortcut keys (i.e. the shift key).

Then I made sure that if the user attempted to open the back-end directly
that it would automatically shut down. Only the application is allowed to
keep the back-end opened. This is done through code.

It wasn't easy but it was possible.

Ray
 
S said:
I want to give the user permissions to alter, insert and delete data into the
tables but I don't want them to be able to export the tables or import them
from inside another database. How can I do this?
Click to expand...

Implement User-level security and make sure that only the owner of the
database has permissions on the tables, no one else. Then have the database
owner create updateable queries for each of these tables and set these
queries with the "Run With Owner Permissions" (RWOP) property. Create your
forms and bind them to the RWOP queries so that the data in the table is
displayed in the form when it opens. Give users only "Open/Run" permissions
on the forms.

Users won't be able to export tables from this database, and they won't be
able to create a new database while joined to the secure workgroup and import
these tables into the new database, either.
 
Back
Top