read only

K

Kay

Why would a new query, just ran, be read only. Any time I
try to delete a record, it says that "data is read only".
Any one that can tell me why please do.

Thanks, Kay
 
K

Ken Snell [MVP]

Making updatable queries (ones that allow you to edit the data) can
sometimes be tricky if you're using multiple tables.

Post the SQL of the query that isn't working for you, and give us info about
the primary key structure and relationships for the tables.

See these MS Knowledge Base articles for more info about updatable queries:

ACC2000: Cannot Edit or Update Record on a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;209571&Product=acc

ACC2000: Status Bar Displays "Recordset Not Updateable" Message When You Try
to Update a Linked Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;304179&Product=acc

INFO: Troubleshooting Errors That May Occur When You Update Data in Queries
and in Forms
http://support.microsoft.com/default.aspx?scid=kb;en-us;328828&Product=acc

ACC: Update Query Based on Totals Query Fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;116142&Product=acc
 
K

Kay

Call me crazy, but I don't know what the SQL is, nor do I
have a primary key or any realtionship. I tried to make a
primary key but I kept telling me I haved a "null" value,
I have no clue what it is talking about. If you can help
some more I would be greatful.

Thanks, Kay
 
K

Ken Snell [MVP]

Without a primary key, ACCESS has no way of identifying each record
uniquely. That is why your query is not updatable. You must set up a primary
key in the table so that each record has a unique identifier.

SQL is the language used by database engines to run queries. In ACCESS, you
can see the SQL statement if you open the query in design view, then click
on the View icon on toolbar and select SQL from the list of options.

I suggest that you obtain a book about ACCESS and read about table
structures and database design. These concepts are crucial to your success
in setting up and using ACCESS databases. There are many good books at
bookstores, and John Viescas (ACCESS MVP) has a list of suggested books at
his website: www.viescas.com.
 
Top