Let's describe the user issue :
User had a database file stored on our SharePoint 2007 environment. (Database into another Database… Uh ? )
The process to reproduce the user's issue :
- Put the .accdb in Check out
- Open the .accdb file
- Making the changes
- Saving the file
- Check in to allow other users to work with the .accdb file
Error got by the user :
Little analysis of the error message : seems that the user had selected an incorrect option while opening the file.
So, I made the same process as the user, but I found a little box that I didn't checked.
- In Sharepoint, do the Check out to avoid having multiple users modifying the file at the same moment
In the "You are about to check out" popup windows, pay attention that the checked box "Use my local drafts folder" is NOT checked
Open the file
In the "Save A local Copy" popup windows, simply click on the Save button.
It is mandatory, as Access had to open the file as if it is on your computer, without any restriction.
- We are using Office 2010, and at the top of the opened database, you can see those 2 yellow warning bar :
- Clicking on the "Save to SharePoint Site" button from the Yellow bar will open the "Save to SharePoint" popup windows, showing that the file will be correctly saved to the Site, as expected.
- System is showing several message windows, and then, we can find the modified database file on SharePoint.
- Now, let's do the Check in of the document.
- Now, the document is Check in without any error.
That's all folks
