We have SharePoint 2010 Server:
2WFE and 1 App
User uploaded Access 2010 Databases to SharePoint document library. When users attempt to open Access 2010 Database the get the following Syn Application Window:
"Sync Failed: Your application has encountered errors while attempting to synchronize with the server. Your Web application may be in bad or incomplete state on the server.
For more details on issues, see the following table:
Move to SharePoint Site Issues 1
Also, you can visit the site here:
You should run the Access Compatibility Checker before attempting to re-sync your application"
I then click on the OK button then I get the following window:
"The RunDataMacro macro action failed because the solution contains links to external data and the database is not trusted"
Then I click on OK button to continue, and it opens the Access DB in read-only mode and cannot edit the database.
I don't know any details on how the database was created. I am against uploading Access DB to SharePoint library.
Any idea on how to resolve the issue?
Do you enable the access services in you sharepoint farm. check this technet how to enable this:
and also check this one:
hopw this help
Thanks -WS SharePoint administrator, MCITP(SharePoint 2010)
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?