Invalid Object Name error. What is this referring to?

[darrel]

I'm trying to delete a record in a table:

Dim strConnect As String =
System.Configuration.ConfigurationSettings.AppSett ings("myConnectionString")
Dim strChk = "DELETE FROM we_admin_users WHERE UserID='" & myUserID & "'"
Dim objConnect As New System.Data.OleDb.OleDbConnection(strConnect)
objConnect.Open()
Dim objCommand As New System.Data.OleDb.OleDbCommand(strChk, objConnect)
objCommand.ExecuteNonQuery()

objConnect.Close()
objCommand.Dispose()

But when I run this, I get this error:

" Invalid object name 'we_admin_users' "

I can run this same function against a different table, and it executes
fine. I can also take the query from above and use it directly in Enterprise
Manager, and it executes fine. Both tables have the same permissions.

So, I'm stumped as to what it things the problem is. What else should I look
at?

-Darrel

[Bruce Barker]

the error means the table we_admin_users in the delete does not exists.
check that the connect string references the correct server and database.

-- bruce (sqlwork.com)


"darrel" <no*****@nowhere.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...

I'm trying to delete a record in a table:

Dim strConnect As String =
System.Configuration.ConfigurationSettings.AppSett ings("myConnectionString")
Dim strChk = "DELETE FROM we_admin_users WHERE UserID='" & myUserID & "'"
Dim objConnect As New System.Data.OleDb.OleDbConnection(strConnect)
objConnect.Open()
Dim objCommand As New System.Data.OleDb.OleDbCommand(strChk, objConnect)
objCommand.ExecuteNonQuery()

objConnect.Close()
objCommand.Dispose()

But when I run this, I get this error:

" Invalid object name 'we_admin_users' "

I can run this same function against a different table, and it executes
fine. I can also take the query from above and use it directly in
Enterprise Manager, and it executes fine. Both tables have the same
permissions.

So, I'm stumped as to what it things the problem is. What else should I
look at?

-Darrel

[darrel]

the error means the table we_admin_users in the delete does not exists.
check that the connect string references the correct server and database.

It does exist. I can put the exact same query into Enterprise Manager and it
runs fine.

It also uses the same connection string as the other function I'm calling,
which deletes from another table, which also works fine.

-Darrel