Solved

Opening an mdb File from SharePoint 2010

Posted on 2013-05-16
22
1,743 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

708 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

19 Experts available now in Live!

Get 1:1 Help Now