ExamGuru IT/.Net Guru : Could not delete from specified tables.. Access 2000 Jet 4.0 on ASPFriends.com 'ngfx-oledb' list

.NETGURU

Could not delete from specified tables.. Access 2000 Jet 4.0

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-oledb' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

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...

Ken Schaefer (VIP)

a) Do you have a primary key defined for the table in question?
b) Do you have any related records in child tables where a key constraint
might stop you deleting the parent record.

I suspect (a) is the problem though.

Also, can you send your mail in plain text please?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Barry Young" <Click here to reveal e-mail address>
Subject: [ngfx-oledb] Could not delete from specified tables.. Access 2000
Jet 4.0

: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
: <HTML><HEAD>
: <META http-equiv=3DContent-Type content=3D"text/html; =
: charset=3Diso-8859-1">
: <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
: <STYLE></STYLE>
: </HEAD>
: <BODY bgColor=3D#ffffff>
: <DIV>I am having a=20
: problem deleting a record from a table with the Jet=20
: 4.0 connection. The SQL string is: Delete From tblUsers =
: where=20
: UserID =3D 'jdoe' When I try to do a ExecuteNonQuery, =
: the=20
: following error occurs: Could not delete from specified=20
: tables... Any Ideas? I read a Microsoft Article that talked =
: about=20
: setting a Unique Record property, but I don't think it applicable to =
: my=20
: problem /=20
: issue. Thanks! Barry </DIV></B=
: ODY>

Reply to this message...

Juan Manuel Guevara Correa

Ken...

I have the same problem. The table has a PK and is a single table (No relations). I try a lot of tricks. The database doesn't have any special permissions.

I realy need help to solve this problem, because i need to finish this project ASAP.

Thk's

--------------------------------
From: Juan Manuel Guevara Correa

Reply to this message...

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification