View Single Post
  #2 (permalink)  
Old 09-20-03, 12:59 AM
Shane Shane is offline
Coding Addict
 
Join Date: Jun 2003
Location: Maryland, US
Posts: 268
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by skchakri
I am getting error while deleting records from the Access2000.

I am sending the Query " DELETE * FROM PersonalMails WHERE mailid=2"
and I am getting error.
Error: -2147467259
Error Description: Could not delete from specified tables.

Plz any body help me in this. I am working on it from 4 days
Thank You.
You don't need the * in the query.

Just: Delete from PersonMails where mailid=2
__________________
Shane Bauer
Microsoft Certified Professional (MCP) - ASP.NET
ASP/ASP.net, C#, VB/VB.NET, PHP, Perl, SQL
Reply With Quote