Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 926803 - Last Review: November 16, 2007 - Revision: 1.4
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"
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.
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.
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:- Right-click the runtime mode database file, and then click Save Target As.
- 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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
APPLIES TO
- Microsoft Office Access 2007
- Microsoft Windows SharePoint Services 3.0
| kberrmsg kbtshoot kbdatabase kbprb kbexpertiseinter KB926803 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate