Delete query

  • Thread starter Thread starter Kelly Postel
  • Start date Start date
K

Kelly Postel

I have a table that I am attempting to delete the most
recent infomation from. I.E. my first field is timestamp
and it currently reads 9/01/03. I need to delete all
records with that date from the table. I have a delete
query set up and it shows the correct information when I
view it but it states that it can not delete from the
table.
 
Sometimes, when there is a join between two tables, the delete cannot occur,
because there is not a unique index or primary key. Access will use this to
determine if the delete can/should occur.

To the One table of the relationship, add a unique index or primary key, and
see if it helps.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top