Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Problem when trying to open MS Access 2003 database file

  Asked By: Miriam Leonard         Date: Jun 19, 2009      Category: Sharepoint      Views: 654
 

I tried to upload a MS Access 2003 database file into a document library, I got
a message saying it has been blocked by administrator. I went to central
administration and deleted mdb, from blocked file types. Then I uploaded it, now
I am facing a problem when trying to open it. When I try to open it I am
getting an error saying "An unexpected error has occurred". How can I resolve
it? Any suggestions?
on my machine I have both office 2003 and 2007 versions.

Tagged:                    

 

4 Answers Found

 
Answer #1       Answered By: Isaiah Santiago          Answered On: Jun 19, 2009       

.mdb's are blocked from uploading specifically because it won't work when
run from within a Document Library. .mdb's must be run from a file  system,
there is no workaround.

 
Answer #2       Answered By: Robert Wilson          Answered On: Jun 19, 2009       

If its just a question of distributing the file, you could zip it or rename
the extension to store it on SharePoint. Obviously you still won't be able
to run it from there though.

 
Answer #3       Answered By: Chase Wagner          Answered On: Jun 19, 2009       

Are you trying to open  the mdb file?

You do not have the same level of access  to a file  in SharePoint
that you do if it on a file system.

If you want the data in the Access DB file to be hosted in
Sharepoint you will have to uplad the data into SharePoint lists. I
think that there is an Access upsized tool to help you do this but I
think that it exists in Access 2007 not 2003.

 
Answer #4       Answered By: Terrance Vasquez          Answered On: Jun 19, 2009       

For whatever reason, Access does not behave like other Office (or
other) documents. We worked with Microsoft even on this one and
found that they have to download a local copy of the file, use it,
and then upload it back. Not desired, of course....but.....

On the flip side, another coworker of mine did some really awesome
stuff exporting lists to Access and joining them to other data
sources (i.e., exported surveys, joined the submitter names to our
central warehouse data etc...). Or...if their database  isn't
an "app", might be worth exploring if any of it could be converted
into SharePoint lists. Of course, if they are related tables or a
more complex "app", that may not be desirable.

 
Didn't find what you were looking for? Find more on Problem when trying to open MS Access 2003 database file Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].