Hi,
i managed to upload .mdb file to the document library. But when i click on the file to open i get "An Unexpected Error has occured". I have Office 2003.
Is this a bug.
Stump the Panel » End Users and Information Workers
cannot open mdb file from the library
(5 posts)-
Posted 3 months ago #
-
What happens when you right mouse click the file, choose 'Save target as...', save it to your harddrive and open it from there?
Posted 3 months ago # -
Please don't put mdb files in a document library. It's just a very bad practice to put a database inside a database (sharepoint is in sql). If you must, must put it in there, zip it up first. That way, users have to download and extract before opening it on their hard drive.
Instead of using an Access DB, put the stuff in sharepoint instead. For each table that exists in the database, create a list in sharepoint. Then, from Access you can connect to all of those lists as if they're tables. Then, you can still do all of your querying and reports from a DB (out on a network share somewhere), but users can input the table data from sharepoint.
Just a thought.Laura Rogers
http://spinsiders.com/laurarPosted 3 months ago # -
Laura - That's an article waiting to happen. -- Mark
Posted 3 months ago # -
Oh yeah. I created a whole project management system in sharepoint from something that a department had in a mdb originally.
Posted 3 months ago #
Reply
You must log in to post.