table read-only on form

  • Thread starter Thread starter short
  • Start date Start date
S

short

I have 6-9 tables on a form (depending on what the user selects) and also on
the form is edit and delete buttons.
But for some of the tables when I press edit or delete it says: records not
deleted data is read-only.

Any ideas?? This is only for a few of the tables.

Thanks,
 
I have 6-9 tables on a form (depending on what the user selects) and also on
the form is edit and delete buttons.
But for some of the tables when I press edit or delete it says: records not
deleted data is read-only.

Any ideas?? This is only for a few of the tables.

Thanks,
Click to expand...

This really sounds like a flawed design. Do you have multiple tables with the
same "shape" - field types and field sizes - and toggle between them somehow?
What is the Recordsource of this form? What is the code behind your edit and
delete buttons?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
DELETE FROM a table WHERE... 1
"Read Only" Query 0
If field is UserReadOnly then make all forms read only 6
Access Form Refresh 1
Linked SQL Tables don't report Cascading Updates and Deletes 2
limit users to use only forms (security, access, write only) 1
Word VBA for deleting Selected Row 0

Back
Top