Permissions issue - users being forced to save table

[RCurtin]

Basically I have a secured split database. Each user has a copy of the FE on their local drive and the BE is on the server. I have 2 main user groups: FinanceUsers and purchasingUsers

Both groups of users edit data directly in the invoice table ( believe me it was not my idea - I am slowly improving it - enforcing relational integrity and fixing the table and field names and creating forms).

When a Finance user edits data in the Invoice table and tries to close it they get a message asking if they wish to save the design changes if they have changed col widths or anything. They just click no and the table closes. (Is there any way to prevent this message coming up? They do not have modify design permission in any case.)

The main problem is that when a purchasing user edits data in the Invoice table a dialog pops up asking if they wish to save the table as a form, data access page or query. (They do not get the message box asking if they wish to save design changes at all)

If the user clicks cancel the window does not close. If they choose 'form' and type a name for the new form for instance it will not save it (presumable because they do not have 'Open Exclusive' permission). So they cannot close the Invoice table at all.

Both groups have the same permissions on the Invoice table: Read Definition, Read Data, Insert Data, Update Data, Delete Data.

The only difference between their permissions is that Finance users have 'Open Exclusive' permission on the database and Purchasing users do not. This is the same in the BE and FE. I would prefer that no-one had open-exclusive permission really.

It is really odd - It only happens with the tables. Any ideas what is causing it?

 

[Treason]

I've see similiar behavior before, and it definitly has to do with opening the tables exclusively in a shared environment. If you dont have the time to create the forms, then simply create a form based on the table that is data view only. It will look just like a normal table but without letting the user "mess" things up too bad.

 

[RCurtin]

Thanks for that Treason.

I would have thought it wouldn't ask you to save tables when you open them in data view and you do not have Open Exclusive permission.

I will do as you suggested and create forms.

 

[RCurtin]

Thanks for that Pat.

It was happening even if you only changed the data (i.e. without changing column widths or sorting or filtering). I've created forms for most of the tables now though.

Thanks,
Rcurtin.