Run-time error 3326 and MDW file

[David]

Hi, all

I am trying to set-up an access 97 database so that my user group staff can
only read data. As this is the first time I have set-up the security mode I
have the following questions:-

I have set the user group so the table has no ticks set which I thought was
all I needed to do. However I get run-time error 3326 "This record-set is
not updateable "and an error statement 2448 so what else do I need to do?

And my final question:-

I have made a new MDW file for this db how do I link it to this database and
have the default system.mdw file still linked to the rest of the databases
and any new db I create.



Thank you

 

[Joan Wild]

Hi, all

I am trying to set-up an access 97 database so that my user group
staff can only read data. As this is the first time I have set-up the
security mode I have the following questions:-

I have set the user group so the table has no ticks set which I
thought was all I needed to do.

I would think you'd want to give them at least Read Data permissions on the
tables. Alternatively, you can remove all permissions and use run with
owner permissions (RWOP) queries for all data interaction.

I have made a new MDW file for this db how do I link it to this
database and have the default system.mdw file still linked to the
rest of the databases and any new db I create.

Use the workgroup administrator to rejoin system.mdw as your default. Then
create a desktop shortcut to launch your secure mdb. Its target would look
like...

"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

 

[David]

Hi Joan
Thank you for the information.

All the best
Dave