By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,435 Members | 2,033 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,435 IT Pros & Developers. It's quick & easy.

Error Message when deleting a file from Access Database

P: n/a
Not sure this is the right place for this questions, but here goes:

I get an error message when deleting an table from a Access database.

The code is as follows and the error message is after it.
***************** Start Code ********************
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.Oledb" %>

Sub Page_Load(Sender as object, e as EventArgs)
if not isPostBack then
'************* Delete previous orders ********
Dim Con As OleDbConnection = New OleDbConnection
Dim DA As OleDbDataAdapter = New OleDbDataAdapter
Dim ConnectString, delCmd, x as String

x = Server.Mappath("\ASPClass\FinalProj\DB.mdb")

ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & x

Con.ConnectionString = ConnectString
delCmd = "DELETE * FROM ORDERS"

DA.DeleteCommand = New OleDbCommand(delCmd, Con)
Con.Open
DA.DeleteCommand.ExecuteNonQuery()
'*********************************************
end if
End Sub
******************** End Code ********************

******************** Start Error Message *****************
Server Error in '/' Application.
--------------------------------------------------------------------------------

Could not delete from specified tables.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Could not delete from
specified tables.

Source Error:
Line 29: DA.DeleteCommand = New OleDbCommand(delCmd, Con)
Line 30: Con.Open
Line 31: DA.DeleteCommand.ExecuteNonQuery()
Line 32: '************************************
Line 33: end if
Source File: c:\inetpub\wwwroot\ASPClass\FinalProj\ShopSignIn.a spx Line:
31

Stack Trace:
[OleDbException (0x80004005): Could not delete from specified tables.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
+41

System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +154
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
+92
System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,
Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +54
ASP.ShopSignIn_aspx.Page_Load(Object Sender, EventArgs e) in
c:\inetpub\wwwroot\ASPClass\FinalProj\ShopSignIn.a spx:31
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +742
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.6018; ASP.NET
Version:1.0.3705.6018

******************** End Error Message *********************
Thank you for your help.

Mark

Jul 22 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a

"Mark" <Ma**@discussions.microsoft.com> wrote in message
news:49**********************************@microsof t.com...
Not sure this is the right place for this questions, but here goes:

I get an error message when deleting an table from a Access database.


This is .net code, so you should be asking in a .net group. They have
"aspnet" in their names.

But, before doing that, make sure your aspnet account has NTFS permissions
to modify the directory that your MDB file exists in.

Also, it's not "DELETE * FROM table..." It's just "DELETE FROM TABLE....

Ray at work
Jul 22 '05 #2

P: n/a
Ray Costanzo [MVP] wrote:
"Mark" <Ma**@discussions.microsoft.com> wrote in message
news:49**********************************@microsof t.com...
Not sure this is the right place for this questions, but here goes:

I get an error message when deleting an table from a Access database.


This is .net code, so you should be asking in a .net group. They have
"aspnet" in their names.

But, before doing that, make sure your aspnet account has NTFS
permissions to modify the directory that your MDB file exists in.

Also, it's not "DELETE * FROM table..." It's just "DELETE FROM
TABLE....

:-)
Not with Access ... the * is required in JetSQL.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 22 '05 #3

P: n/a

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eO**************@TK2MSFTNGP14.phx.gbl...

Also, it's not "DELETE * FROM table..." It's just "DELETE FROM
TABLE....

:-)
Not with Access ... the * is required in JetSQL.

I thought that was only the case with MDAC2.5 and older or something like
that. I believe the more recent versions of Jet are cool with not using the
*.

Ray at work
Jul 22 '05 #4

P: n/a
Ray Costanzo [MVP] wrote:
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eO**************@TK2MSFTNGP14.phx.gbl...

Also, it's not "DELETE * FROM table..." It's just "DELETE FROM
TABLE....

:-)
Not with Access ... the * is required in JetSQL.

I thought that was only the case with MDAC2.5 and older or something
like that. I believe the more recent versions of Jet are cool with
not using the *.

Really? I'll have to try that ... yes, I guess you're right. But the * still
works fine.

Bob
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 22 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.