Message with Data is Ready-Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am having trouble deleting records from a form. I recently converted the
database from 97 to version 2003. After converting the database everything
seemed to be fine. Several weeks after the conversion I needed to update one
table. This table is one of my main tables that we use. On one of the forms
that we use, I get a message "Data is Read-only". I need to update the
table through this form by deleting and changing records. I checked the
database properties and the read-only box is not checked. I also check the
forms properties and the "allow deletions" is set to Yes. How can I fix
this to allow me to edit the form?

Thanks,

Robin Bramblett
 
What is the RecordSource of this form? Is it just the table?
Or is it a query or SQL statement that uses multiple tables?

If a query, can you delete records directly from the query?
If a table, do you get the same message if you try to delete from the table?

What is the RecordsetType property of the form?

Can you edit records in this form?

Have you set up Access security (mdw)?

Examples of things that will make a query read-only:
.. It has a GROUP BY clause (totals query).
.. It has a TRANSFORM clause (crosstab query).
.. It contains a DISTINCT predicate.
.. It uses First(), Sum(), Max(), Count(), etc. in the SELECT clause
(performs aggregation).
.. It involves a UNION.
.. It has a subquery in the SELECT clause.
.. It uses JOINs of different directions on multiple tables in the FROM
clause.
.. The query's Recordset Type property is set to Snapshot.
.. The query is based on another query that is read-only (stacked query.)
.. Your permissions are read-only (Access security.)
.. The database is opened read-only, or the file attributes are read-only, or
the database is on read-only media (e.g. CD-ROM, network drive without write
privileges.)
 
I have a totals query, which will render it read-only:

But according to a microsoft access help website, their procedure (to
delete duplicate records) was to first create a totals query to grab
the distinct records with a First, Min, Last, etc clause, then create a
Delete Query based on the totals query.

I get the "could not delete from specified tables" error. I dont have
any joins between my totals query and main table (underlying table).

How do i get around this??
Herman
 
Mr. Browne,

This post prompted me to e-mail you directly. This may be improper and I
apologize to you and to the users of this forum if it is. I'll just repeat
the question I asked earlier and hope I haven't abused any priviledges or
offended anyone.

The question was:

I want an updatable form that behaves like a crosstab query (or rather like
an Excel Spreadsheet), so that our users in payroll can observe the weekly
hours of all our employees as they are being updated. Is this easily done?
I'm using two tables. Employees (Name, position, location, contact info,
etc.) and Hours (date, hours worked, vacation time, etc.) I've combined them
in a select query, and organized the data in a crosstab query. Now I'm
stuck. Do you have any advice? Perhaps you could direct me to a resource
where I could figure this out on my own?

Hopefully, there are others that could benefit from this information as well.

John Byrd aka jaybird
 
You can create a form that looks like a crosstab provided the field names
are static (perhaps aliased) or the ControlSource of the controls is
assigned in the Open event of the form. Results will be read-only of course.

The other alternative is to create a temp table so the user can enter the
values, and then execute append/update/delete queries on the real tables.

Others may have suggestions in the groups.
 
Back
Top