ACCESS2003

[Gambler]

I installed access 2003. In office 2000 when i wanted to delete records from my query I would clilck up in the upper corner and then everything would be highlighted and i would hit delete. When i do this in office 2003 it tells me it is a read only file. How do i delete that race out so i can enter another one?
thanks ed

[Rick]

I don't have an answer for you.

I just tried deleting in a query that way and had no trouble doing so.

Can you delete records from your table?

Did you get any message box when you opened the table?

I remember times I would open tables and would get the message that it was in read-only mode.

[Rick]

Found this in the newsgroups. Check to see if your primary key is intact for that table.



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.

--

Ken Snell
<MS ACCESS MVP>



"Kay" <kwickham@stecoinc.com> wrote in message
news:9aee01c49746$ce341080$a301280a@phx.gbl...
> 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
>
>
>
>
> >-----Original Message-----
> >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
> >
> >--
> >
> > Ken Snell
> ><MS ACCESS MVP>
> >
> >"Kay" <kwickham@stecoinc.com> wrote in message
> >news:923b01c496ae$b18d9b60$a501280a@phx.gbl...
> >> 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
> >
> >
> >.
> >

[Gambler]

I have to go now. Steelers. I will try it as soon as i get back.

[Gambler]

Thanks Ricks. I was in the query mode and not in tables. Once I read you post all was fixed. I sure worked on tht one a long time.
Where does one find that newsgroup you use as a reference?
Thanks ed

[Rick]

The newsgroup I found that info in was microsoft.public.access.queries

You can still delete records in queries.