Search:  
NamespacesDiscussions.NET v1.1Feedback
Access Database Problem...
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-odbc' list.


Barry Young
I am having a problem deleting a record from a table with the Jet 4.0
connection.

The SQL string is:

Delete From tblUsers where UserID = 'jdoe'

When I try to do a ExecuteNonQuery, the following error occurs:

Could not delete from specified tables...

Any Ideas? I read a Microsoft Article that talked about setting a Unique
Record property, but I don't think it applicable to my problem / issue.

Thanks!

Barry
Reply to this message...
 
    
Tim Curtin
make sure the table has an index. Also, you have to close the Access
database when running the code. Access keeps a process lock on the mdb.

[Original message clipped]

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
Reply to this message...
 
 




Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com