lock a table for edits and only allow new records in a form

[dfanny]

New to this forum..
I would like to replicate a procedure I saw on a system in a workplace. The database opened with predefined form and the only way to see the access objects was by hitting F11. Could not get into the database by holding shift while opening ( I know there are methods to stop this). While in the database view I could open a table but make no edits to it, was also locked out of modifying the form. When using the database thru a form, the form would allow a new record to be added but the record could not be edited. NO user password needed to be entered to open the database which is stored on a shared network drive. Any ideas.
Thanks

 

[willir]

dfanny

First, was this an Access database?

Next, was it a compiled MDE file? You can not edit forms, reports in an MDE file.

Setting properties in the form can allow the user to add entries, but not change the records. These same properties can be set programatically.

Me.AllowEdits = True / False
Me.AllowDeletions = True / False
Me.AllowAdditionas = True / False

Me.DataEntry = True / False (T = data entry only)

Richard

 

[dfanny]

This is an access database (access 2002) and it is not an mde file. What I am having a hard time understanding is that the table behind the form (obtained directly from the database window) will not allow edits. I see no property to prevent edits here.

 

[willir]

dfanny

Okay, is this a linked table? You are right, since you do not login, I am unaware of any property setting to prevent you editing the table.

Perhaps you can look at the "User and Group" Permissions. Select a table and see if any security has been applied. (Tools -> Security)

Richard