Access ERROR!

[BRASILO]

Does anyone know how to turn off the Record is deleted. error? I've used all the error trapping. However, I think this is an API. Anyone know how to suppress it? This only happens to linked tables in SharePoint10 and not on stand alone DBs.

[Gicu]

Do your Sharepoint lists all have primary keys defined? Have you tried to compact and repair?
There are some other posts regarding this, try to search for access + SharePoint + record is deleted:
https://access-programmers.co.uk/for...d.php?t=243864

Cheers,
Vlad

[BRASILO]

Do your Sharepoint lists all have primary keys defined? Have you tried to compact and repair?
There are some other posts regarding this, try to search for access + SharePoint + record is deleted:
https://access-programmers.co.uk/for...d.php?t=243864

Cheers,
Vlad

Vlad, thanks for the suggestions. All my lists do have primary keys. That's why I find it odd. All was well and than it started give me that message. None of my records are deleted or show deleted. It's when I use a form to update the information on a table that it gives me this message. Very strange.

[Gicu]

Can you update the table (list) directly? Does your form and its recordsource contain the primary key field?

Cheers,
Vlad

[BRASILO]

Can you update the table (list) directly? Does your form and its recordsource contain the primary key field?

Cheers,
Vlad

I can update the tables/list directly and no errors or issues. Also, I can pull the records with no issues. Once I use a form to edit the record than I get that error. It's very strange.

[BRASILO]

Can you update the table (list) directly? Does your form and its recordsource contain the primary key field?

Cheers,
Vlad

I found a work around. Although it would be great to find some code to turn off that ERROR! API. It was really annoying. I ended up using a Currentdb.execute SQL to piggy back on the ID twice to make sure that the form only took that one ID.