Solved

Open Access MDB file from SharePoint

Posted on 2009-07-05
7
1,150 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 15

Accepted Solution

by:
dp_expert earned 500 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

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 case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

695 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