[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1985
  • Last Modified:

Opening an mdb File from SharePoint 2010

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
EMCIT
Asked:
EMCIT
  • 16
  • 6
1 Solution
 
Bill RossCommented:
Hi,

You cannot open an mdb from sharepoint.  

Regards,

Bill
0
 
Bill RossCommented:
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
 
Bill RossCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
EMCITAuthor Commented:
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
 
Bill RossCommented:
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
 
Bill RossCommented:
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
 
Bill RossCommented:
So.....I changed the mdb to an accdb and it opens fine from within SP.

I suspect much functionality is lost.
0
 
EMCITAuthor Commented:
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
 
Bill RossCommented:
Where is the accdb stored - on the LAN or on Sharepoint?
How is the user getting a "Copy of the latest file."?

Bill
0
 
EMCITAuthor Commented:
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
 
Bill RossCommented:
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
 
Bill RossCommented:
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
 
EMCITAuthor Commented:
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
 
Bill RossCommented:
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
 
Bill RossCommented:
The link path will probably look like:

\\123.456.789.123\SomeSharedFolderName\SomeSubFolderName\DocumentSubFolder\filename

Regards,

Bill
0
 
Bill RossCommented:
\\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
 
Bill RossCommented:
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
 
EMCITAuthor Commented:
I wouldn't think so. It is a seperate server
0
 
Bill RossCommented:
Then you cannot create a link to the local file from sharepoint.

Bill
0
 
Bill RossCommented:
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
 
EMCITAuthor Commented:
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
 
Bill RossCommented:
Glad to help!

Bill
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 16
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now