When I open a Microsoft Office Database that is on my Sharepoint 2010 portal, it does indeed, open Microsoft Access 2010, but it says, "Read Only This database was connected to a Microsoft Access Services site that is not compatible with this version of Microsoft Access. You cannot make design changes or modify data in this database."
It also tells me, upon saving and opening a database in Access, "The RunDataMacro action failed to invoke a data macro on the server. Please check your connectivity to the server."
Now, the server is running Sharepoint Server 2010 Enterprise, and I have Office 2010 Professional on my own Windows7 64bit computer. I am admin in both places, and using a Domain Admin account.
I have even set Access Trust Center options to "enable all macros", and "enable all activex" along with disabling safe mode. I have added the portal site to "trusted locations", and checked "allow all documents on network to be trusted."
How can it not be compatible? Have I not configured something in Sharepoint Server?