Runtime error 3086:Could not delete specified tables

[Guest]

Hi ,
I got error message ever since Acees 97 database was converted into Access
2002. Nothing has been changed. ODBC connection is fine. Linked ODBC also
fine. DNS configurarion is okay. However, when I click on command button
named "Synchronize", it returned an error as above from Access 2002.
Synchronizing will be performed between Access data base and Web database
which is running on web server based on Oracle. Local client has Oracle
client 92.

The below code is being used since Access 97 for the command button on the
form:FRM_Synchronize.
----------------
Option Compare Database
Option Explicit
--------------------------------
Private Sub Command0_Click()
Form.SetFocus
Text1.Value = "Synchronizing... please wait ..."
Text1.SetFocus
Command0.Enabled = False
DoEvents
CurrentDb.Execute "DELETE FROM WEB_PROPERTY"
CurrentDb.Execute "INSERT INTO WEB_PROPERTY ( PROPERTY_ID, ..., ..., ,
...._NAME ) SELECT [INVENTORY - MASTER].ID, [INVENTORY - MASTER].Low, ...,
FROM [INVENTORY - MASTER];"
DoEvents
Text1.Value = "Done"
MsgBox "Done"
Command0.Enabled = True
End Sub

--------------------------

Debug always stopped at CurrentDb.Execute "DELETE FROM WEB_PROPERTY". I
found the fact that error # 3086 stands for "Web Query"

Would appreciate your help. I want to know how to make it work as it did
with Access 97.
Many thanks,

 

[TC]

I assume the message is, "cannot delete FROM specified tables"?

There's nothing apparently wrong with the SQL, so it sounds like a
permissions problem. If you open that table directly, in datasheet
view, can you manually delete a record from it?

PS. This is not the cause of your problem, but, it is very inefficient
to use CurrentDb like that. Every call to CurrentDb, refreshes all the
collections (in memory). That is quite an operation. It's generally
better to cache the value in a variable, and use it from there:

dim db as database
set db = currentdb()
db.execute ...
db.execute ...
(etc.)
set db = nothing

HTH,
TC [MVP Access]

 

[Guest]

It was "could not delete FROM specified tables".
I am not able to delete or add any record from the datasheet view. If I
could, I can manually update some records directly from datasheet view.
However, it's not.
The security feature for this Access data base allows "Administrator and its
members" Full access permission on Access data base end. I used 'Admin' and
'user' in admin group. But the rsult was same. I am not an Oracle / Web
person. Thus, I asked the person who was working on Oracle/WEB end about the
situation. But he said the same 'permission issue'. I have been stuck for
about two weeks here. Do I have to ask him again to look into permission
issue on his end? I don't have any clue why he has not replied any to my 5-6
times of email questions/suggestions. Again, I did not change anything
except for data conversion from Access 97 to Access 2002.

While I may attempt to apply your code, I still need helps from persons like
you.
Many thanks in advance.

 

[TC]

It was "could not delete FROM specified tables".

Ok, as suspected.

I am not able to delete or add any record from the datasheet view. If I
could, I can manually update some records directly from datasheet view.

So the problem is really nothing to do with the "synchronize" code that
you mentioned before. The problem is, that the linked table seems to
be read-only. The problem is nothing to do with the synchroniz code, as
such. Yes?

The security feature for this Access data base allows "Administrator and its
members" Full access permission on Access data base end. (snip)

Three questions:

(1) Has the database actually been secured using Access user-level
security? If so, do you still have contact with the person who did
that?

(2) Exactly how do you start the database up? Do you click a shortcut,
or double-click the mdb file, or what?

(3) Are you doing (2), exactly the same way that you did it before (in
the previous version of the database)? Or has (2) changed somehow,
betwen the two versions?

HTH,
TC [MVP Access]

 

[Guest]

I found I missed to check the "primary key" from the converted ODBC linked
tables in Access 2002. I re-created linked ODBC tables and made the same
table property as identifier(primary key) as those in Access 97. Then, I was
able to add records from data sheet view of the table, after I opened the
table by linked ODBC.

I click "Synchronize" command button from FRM_Synchronize:From. It will show
text "Done" in the text box when it is completed. Since, the data base is
live, I did not attempt to click the command button yet. I will ask the
person who is taking care of Sync. to see the result.

Thanks,

It was "could not delete FROM specified tables".

Ok, as suspected.

I am not able to delete or add any record from the datasheet view. If I
could, I can manually update some records directly from datasheet view.

So the problem is really nothing to do with the "synchronize" code that
you mentioned before. The problem is, that the linked table seems to
be read-only. The problem is nothing to do with the synchroniz code, as
such. Yes?

The security feature for this Access data base allows "Administrator and its
members" Full access permission on Access data base end. (snip)

Three questions:

(1) Has the database actually been secured using Access user-level
security? If so, do you still have contact with the person who did
that?

(2) Exactly how do you start the database up? Do you click a shortcut,
or double-click the mdb file, or what?

(3) Are you doing (2), exactly the same way that you did it before (in
the previous version of the database)? Or has (2) changed somehow,
betwen the two versions?

HTH,
TC [MVP Access]