?
Solved

Open Access MDB file from SharePoint

Posted on 2009-07-05
7
Medium Priority
?
1,167 Views
Last Modified: 2013-11-27
Is there a way to create a hyperlink to an Access database (MDB) format from within SharePoint on our Department site?

I will not be moving our Access database to SharePoint due to the issues with referential integrity, keys, etc.

Thanks for your assistance.
0
Comment
Question by:jrogersok
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 24783107
I feel there must be more to your Q than you have stated.
If you add a hyperlink to the database file then clicking the link should open the database, assuming the user has Access installed on their machine.
0
 
LVL 15

Expert Comment

by:dp_expert
ID: 24783601
You can use "Content editor web part" to place a link anywhere on the web part page, or use the navigation tools to put in on the top/left menu (in MOSS it is under "Navigation" in the site actions menu, in WSS it is "Quick launch" and "Top link bar" on the site settings page.

Make sure that people will have access to the machine that is hosting the MDB file - for ex. if your intranet is pulished in the internet and the file is on local share, then it will not be accessible without VPN
0
 
LVL 2

Author Comment

by:jrogersok
ID: 24787458
From what I've been reading MDB files are blocked by SharePoint.  Is this correct?  (There's so much info floating around the internet that it's difficult to weed through all the articles).

I just need a basic link to open the database which will be housed on a Shared network drive.

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 15

Accepted Solution

by:
dp_expert earned 2000 total points
ID: 24787617
If you do not want to place the file on the SharePoint, you just have to place it on a network drive and add a link to the file on the site, so users will know where it is. To add the link you either need to use the content editor web part, the "Links" list, other webpart or the navigation.
Even if MDB files would be disabled you can easily allow them through the central administration (cetral administration -> operations -> locked file types (under security - second group from the top in the left column)
0
 
LVL 2

Author Closing Comment

by:jrogersok
ID: 31600010
Thanks so much!
0
 
LVL 2

Author Comment

by:jrogersok
ID: 24807864
Can't seem to find the Central Administration link (we have a custom built template from our IT department).  Is it only available at the Designer level?  If not, any suggestions on what part of the screen it is located in?
0
 
LVL 2

Author Comment

by:jrogersok
ID: 24807876
How would one go about adding a link to a shared drive on a network from within Sharepoint?

Thanks for all your help.  It's really appreciated.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

771 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