How can I fix this "Cannot Update. Database or object is read-only" error?

Question

I created a database with a link to a sharepoint list. I have full control access to this same sharepoint list. When I try to append to this list I get the error seen below. However, this error doesn't appear immediately, usually it will successfully append couple hundred or thousand records before the error is displayed. How can I fix this error?

Answer 1

Hi,

How do you append the data? With queries?
What do you have to do, so that it does work again? Close the db or refresh the link or relink the lists or...?

Although caching usually is a good idea and improves the performance, you could try if Method 2 from this support page helps also with your problem variant.

There are other known causes like this one but that doesn't really fit to your description either.

Servus
Karl
-------
Access Bug Trackers
Access News
Access DevCon