form not letting field contenst be edited

[stumpydwarf99]

I have an access database.

there is a table called leads. one of the records in that field has the name called another field has the name telemarketer.

I have a select query that finds all records in the leads table where field called = no and telemarketer = x.

There is a form based upon this query which shows each record meeting the criteria so that the telemarketer can make there calls.

When I open the form from the switchboard in edit mode I can change the contents of the fields.

However when the telemarketer does so it does not let him edit the contents of the fields.

I thought this might be due to security permissions, so I set the user permissions for another user to be the same as mine on the table, the query and the form, however the issue still occurs.

can anyone help me with what my mistake is?

 

[MStef]

As I can uderstand you, your MDB is on server, and there are more users.
Tell your system engineer to give all perimissions for all users, on a directory where the MDB is.
I think it'll help.

 

[gemma-the-husky]

try opening the query directly, and see if you can edit items directly

some queries become non-updateable, because of the way the query is structured

Access help gives info on this, or search here - "why is my query not updateable"