Error messages when you try to use Access 2007 to open a runtime mode database file in a Windows SharePoint Services 3.0 document library: "Microsoft Office Access cannot open this file"

View products that this article applies to.

Expand all | Collapse all

SYMPTOMS

Consider the following scenario:

You open a Windows SharePoint Services 3.0 document library.
You locate a Microsoft Office Access 2007 runtime mode database file (*.accdr) in the document library.
You click the down arrow for the runtime database file, and then you click Edit in Microsoft Office Access.

In this scenario, you may receive the following error messages:

Some files can harm your computer. If the file information looks suspicious or you do not fully trust the source, do not open the file.
You are opening the following file:
Filename: database_name.accdr
From: SharePoint_server

Microsoft Office Access cannot open this file.
This file was converted to runtime mode by changing its file name extension to .accdr. This file will open only when Access is in runtime mode.
To open the file, either double-click it in Windows Explorer, open it by using a shortcut, or use the /runtime command-line switch.
To modify the design of this database, rename it with an .accdb file name extension, and then open it in Access.

Back to the top

CAUSE

This problem occurs because Access 2007 does not support the direct editing of runtime mode database files. The Windows SharePoint Services 3.0 document library incorrectly indicates that you can edit Access 2007 runtime mode database files in Access 2007.

Back to the top

WORKAROUND

To work around this problem, follow these steps:

In the Windows SharePoint Services 3.0 document library, click the down arrow next to the runtime mode database file, and then click Check Out.
Click OK when you are prompted to save the runtime mode database file to the local drafts folder on the computer.

Note By default, the runtime mode database file is saved to the following folder:
%userprofile%\My Documents\SharePoint Drafts
If you are not prompted to save the file to this folder, follow these steps:
1. Right-click the runtime mode database file, and then click Save Target As.
2. Click My Documents in the left pane, open the SharePoint Drafts folder, and then click Save.
Click Start, click Run, type "%userprofile%\My Documents\SharePoint Drafts", and then click OK.

Note If you saved the runtime mode database file to a folder other than the local drafts folder in step 2, open that folder in Windows Explorer.
In Windows Explorer, locate the runtime mode database file in the folder that you opened in step 3.
Right-click the runtime mode database file, click Rename, and then change the file name extension to .accdb.
Double-click the runtime mode database file.
Edit the runtime mode database file in Access 2007, and then save any changes that you make.
In Windows Explorer, right-click the runtime mode database file, click Rename, and then change the file name extension to .accdr.
In the SharePoint document library, click the down arrow next to the runtime mode database file, and then click Check In.
Click Ok on the Check In page, and then click Yes to confirm that you want to upload the file.