How can I give full access to 1 table in read-only MSAccess file?

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

Guest

Is this possible to give read+write access to 1 table in read-only MS Access
file?

I've 3 forms in my program with ~10 Event Buttons. When read-only access
people click on Button1, database(Table) should be updated. Is this possilbe?
 
Hi,
your users should have no direct access to the table level. They should
write/read/edit data only on forms. You can set up some sort of security
which checks who currently is in the db and based on that just give that
person the specific permissions by enabeling disabling things.
Furthermore is this application split into a Frontend and Backend set up.
Since multiple users are using it, it is vital to split the application.
HTH
Good luck
 
Is this possible to give read+write access to 1 table in read-only MS Access
file?
Click to expand...

No. Read only means just that - the database is read-only.
I've 3 forms in my program with ~10 Event Buttons. When read-only access
people click on Button1, database(Table) should be updated. Is this possilbe?
Click to expand...

You can implement Access security on the database, and don't give the
users any update privileges on any of the tables; you can use "RWOP
Queries" to update the data from code. This is not a trivial
undertaking but it's certainly doable, and would be the best bet if
you really want to keep users from messing with the data.

John W. Vinson[MVP]
 
Back
Top