Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Problem when trying to open MS Access 2003 database file

  Asked By: Miriam    Date: Jun 19    Category: Sharepoint    Views: 2136

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.



4 Answers Found

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

.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

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

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

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.