erroneous record in use error with sql linked tables

  • Thread starter Thread starter msmcnewsxp
  • Start date Start date
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.
 
Back
Top