Record Is Deleted.

G

Guest

I am running an append query utilizing data from a linked table and linked
ODBC tables from an AS400.

The resulting records are appending to another database.

The query starts to run. About 1/ the way through I get the above message.

I have completed a compact and repair on all Access databases and still
receive this message.

Any help would be appreciated.
 
B

Bill Mosca, MS Access MVP

Bev

You might try a refresh or a requery after the delete. Sometimes Access
can't stay up on a linked non-Jet table's indexing.
 
G

Guest

I guess the problem is I don't know what is deleted? I get this message when
I run an append query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My access fron-end is slow 2
Append query to ODBC linked table in SQL Server 19
best way to make linked database - Stand alone 3
Append only Null records in table 2
Linked SQL Tables don't report Cascading Updates and Deletes 2
System resource exceeded with linked ODBC MS SQL 2000 table 1
Number format 4
Suppress warnings, but show error messages 2

Top