erroneous record in use error with sql linked tables

M

msmcnewsxp

i'm using a form that is bound to a linked sql table.
i get an error message when trying edit record that says the record is in
use do i want to save data to clipboard or abort.
the record is not in use.
to fix i have to export the table from sql, drop it, re-import it, change
ownership, create primary key and it will work fine.
i'm using several other forms with sql linked tables and never have a
problem.
this occurs when ever i have to update.

i use a linked MDB for development.

any clues?

i will post this on adp sql group as well.
 

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

Linked SQL Tables don't report Cascading Updates and Deletes 2
query links to SQL server and mdb table 1
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Using Application Roles with Access MDB's 0
QBF & Query Malfunction 0
Access FE, SQL BE, Some tables, won't let me edit (or delete) my records! 0
linking to SQL Server db table 6
Linked tables not using SQL Login 0

Top