How to acces in read/write a checked out document ?

Today, I had to explain to a Site Collection Admin how I unlock a file on his SharePoint 2007 site.

The file was checked out by a user that was no more working in his team.

This post resume the steps I explain to the end-user :

1-      Check that the Icon is in "check out"

2-      Two options:

Ø  Check In : make your changes visible to your colleagues, and create a new version (if the versioning option is set)

Ø  Discard Check Out : will discard changes, and the main advantage, is to avoid making new versions of the document when not changes are made into the file.

Complete info can be found on the Microsoft Support Page

That's all folks 

MOSS 2007 : Data changes are lost after Check in of .accdb file

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