I have an access database linked to several tables in SharePoint. One of the tables is an inventory list that records which location stock items are in.
The problem is that this Access database doesn't always sync 100% with what's in the SharePoint tables. You can make changes and sometimes they will be reflected in the table in SharePoint, but sometimes they won't.
For example, I went directly into the Inventory table in SharePoint and adjusted 1 field in 10 records to say that the items had been moved. But looking at the Access frontend it's still showing me the old information.
I have a Refresh button on the form, but that doesn't seem to make a difference. The computer with the Access database on it is online and connects to the internet fine. It shows (in the bottom right hand corner) that it is "Online with SharePoint"
What am I doing wrong?
The problem is that this Access database doesn't always sync 100% with what's in the SharePoint tables. You can make changes and sometimes they will be reflected in the table in SharePoint, but sometimes they won't.
For example, I went directly into the Inventory table in SharePoint and adjusted 1 field in 10 records to say that the items had been moved. But looking at the Access frontend it's still showing me the old information.
I have a Refresh button on the form, but that doesn't seem to make a difference. The computer with the Access database on it is online and connects to the internet fine. It shows (in the bottom right hand corner) that it is "Online with SharePoint"
What am I doing wrong?
