Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Access 2007 ribbon -

  1. "Move to SharePoint"
  2. My Network Places
  3. Open the file on the SharePoint to save it in, name it, click ok. I get a msg "Plase save to document library. So I go to shared documents on the SharPoint create a file, save the database and I get an error: "Microsoft Office Access cannot perform the export operation".... Why not? the steps are simple, but this msg tells me nothing as to why it cannot save it. Could someone pls help me get this Access db on the Sharepoint so the users can start using it?


share|improve this question
Sorry, hit submit to soon... Steps 1-3 just show what I'm doing.. – LtDan Jun 21 '11 at 14:21
Is this your front end to SQL Server? Moving to Sharepoint means "moving your Access data tables" to Sharepoint, if I'm not mistaken. If you don't have any, you don't have anything to move. – David W. Fenton Jun 23 '11 at 1:35
up vote 0 down vote accepted

I believe SharePoint does not allow Acess DBs as a permitted upload unless changes are made to the permitted list on the site. Are you the site admin? If not, check with them to see if Access DB files are permitted or not. Some files like EXEs are not permitted to avoid folks trying to run them directly from the site. Assume same applies to the DB as trying to open would present a challenge.

share|improve this answer
I have full access to the site but I'm not the actual admin. With that said, how do I allow users to use the database, assuming I cannot upload the entire database? – LtDan Jun 21 '11 at 15:08
First thought is back to the file share. – Dave M Jun 21 '11 at 15:13
Not the direction I was hoping to go... Thanks – LtDan Jun 21 '11 at 17:29

If someone finds this post like I did. A way round it is to create the tables in SharePoint first. Then from SharePoint open in Access (Actions view in access).

Then create the forms and queries from the linked tables. If the database is already created just make sure you name all the lists and columns the same as your old tables and you should be able to copy the forms from the old database to the new linked one and they still work.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.