Append query losing records when Access exited.

S

Seano

Hi Access Gurus,

Here's a tuffy.

My Access 2000 table is linked to a SQL 7 table. When I add 80 odd records
via a Access append query (with no errors), they remain in there while I am
in Access.

Investigating why I can't access the table at the same time elsewhere, I
found the Append query has put a table lock in SQl, in such a way as when I
exit Access, the records (and the table lock) disappear. There is a Primary
key on the table.= and I have been using the Access.mdb and SQL database
for years.

Any ideas out there?

Sean
 
Top