Solved

Opening an mdb File from SharePoint 2010

Posted on 2013-05-16
22
1,760 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
 
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Why can't I get my report to SORT correctly? 5 26
DSum for Access 6 43
is there a opposite on ON CURRENT in ms/access 15 31
ms/access hyperlink/ftp 7 31
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

929 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now