Vassago
Former Staff Turned AWF Retiree
- Local time
- Today, 18:17
- Joined
- Dec 26, 2002
- Messages
- 4,751
Dave R said:I don't know if Vassago's problem was ever resolved but I have just come across the same thing and discovered it is to do with Access 2000 Jet engine 4. When you dsign a query in Access 2000 the "Unique Records" property defaults to "No". In the query design, go to View then Properties and set "Unique Records" to "Yes". The delete query should then work. For more info see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;207761
While I could never find a solution to this problem, I did discover a work around. Unfortunately, this article doesn't apply for me, as I am using Access 97 and I had the properties set correctly. My solution was a lot like Len described above.