Solved

Opening an mdb File from SharePoint 2010

Posted on 2013-05-16
22
1,802 Views
Last Modified: 2013-05-22
I have uploaded an mdb file to SharePoint. I have created a link and placed it on a site page. The link, however does not open the file. Couple of questions - How can I open this file from SharePoint or if I place the file on our LAN what would the path be to open this file from the link on the SP page? Thanks in advance for your assistance.
0
Comment
Question by:EMCIT
  • 16
  • 6
22 Comments
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39171849
Hi,

You cannot open an mdb from sharepoint.  

Regards,

Bill
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39171858
Further explanation...

MS Access is a file based database so the file must be opened on a file system.  You could download the file from sharepoint but that creates numerous issues.  It's not like sharing a word document, say.  This is due to the simultaneous user capabilities of the file.

You can only have one user open a word document but you can have hundreds opening an MS Access database file.

Bill
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39171870
If you put the file on your LAN then it will need to be on a shared folder where all users have full access to the folder.

You can then create a shortcut to the file.

Not through sharepoint though - just a regular desktop shortcut.

Bill
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 11

Author Comment

by:EMCIT
ID: 39172029
So.....I changed the mdb to an accdb and it opens fine from within SP. I would like a current copy of the front-end to reside on our LAN. The app that loads in SP will take a copy of the front-end from the LAN and then open the copy. I can't get the syntax right for the hyperlink to look to the LAN. Thank you
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172041
Hi,

Where does the backend reside?

It might open fine but what's really happening may not allow data to be saved.  Please check the accdb and make sure you can edit and save data in a multi-user situation before continuing.  I suspect not...

Bill
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172055
You can link to a sharepoint file by right clicking the file and click Copy Link Address from within sharepoint.  I don't thank that's what you're looking for though.

Bill
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172060
So.....I changed the mdb to an accdb and it opens fine from within SP.

I suspect much functionality is lost.
0
 
LVL 11

Author Comment

by:EMCIT
ID: 39172070
The most current copy of the front-end will have links to lists on SP that have been exported as tables from the original accdb. The file that is opening in SP is fully functional and writes back to the lists as required. So the piece that is missing is the proper structure of the path to the LAN.......something,something "X:\FolderWhereFileIs\TheFile.accdb". We're getting there! Thank you.
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172079
Where is the accdb stored - on the LAN or on Sharepoint?
How is the user getting a "Copy of the latest file."?

Bill
0
 
LVL 11

Author Comment

by:EMCIT
ID: 39172107
I actually only need SP to, via the hyperlink, launch a file on the LAN. That file has one form that loads. It makes a copy of the current front-end (on the LAN) and then pastes it on the user's desktop and then opens the current front-end copy. The first file then closes.
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172132
OK.  Now I think I understand.

You will need to use the full URL of the file as SharePoint sees it which is different from the way the file is seen on the network.  Virtual directories are used.

\\servernameoripaddress\sharepointDavWWWRoot\Documentfolder\filename

You may need to log into SharePoint admin to find the exact info.

Bill
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172143
You may also need to set LAN permissions for the sharepoint service account if these are not set up already.  Sharepoint saves files in SQL not in the file system.
0
 
LVL 11

Author Comment

by:EMCIT
ID: 39172156
So what should the link path look like:

What is missing from this path. When I use this nothing happens.

X:\FolderWhereFileIs\TheFile.accdb
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172204
X:\FolderWhereFileIs

The Sharepoint server does not know what X:\FolderWhereFileIs means.  

Sharepoint is a web server so links are from that point.

If you look in explorer on your workstation X:\ is a mapped drive that is unique to your log in.  The sharpoint service account would need the same mapping but this is a BIG security hole so probably won't happen.

Some questions to help further:
Who administers your sharepoint server?
Where does the sharepoint server reside?

Regards,

Bill
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172211
The link path will probably look like:

\\123.456.789.123\SomeSharedFolderName\SomeSubFolderName\DocumentSubFolder\filename

Regards,

Bill
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172220
\\123.456.789.123\SomeSharedFolderName\SomeSubFolderName\DocumentSubFolder

will be a virtual folder on the sharepoint server pointing to an actual physical folder on the lan that's been shared for the Sharepoint service account access.

Bill
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172228
A quick test.  Assume you were physically sitting at the sharepoint server computer - would you see X:\whatever when logging in as the sharepoint service account?
0
 
LVL 11

Author Comment

by:EMCIT
ID: 39172259
I wouldn't think so. It is a seperate server
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39172287
Then you cannot create a link to the local file from sharepoint.

Bill
0
 
LVL 14

Accepted Solution

by:
Bill Ross earned 500 total points
ID: 39172297
There is a reason for this - security.  You wouldn't want to share LAN files on your sharepoint server.

Maybe give the user instructions for creating the shortcut on their desktop???  You can put that on sharepoint.  Then is users don't have permission for X:\... there is no security risk.

Bill
0
 
LVL 11

Author Closing Comment

by:EMCIT
ID: 39188718
Thanks for your assistance. I used the SP Site to launch the accdb that is on SP, I then coded the path to the file I need to copy in VB in the On Load of a form. This seems to do the job nicely.
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39189029
Glad to help!

Bill
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question