Solved

Open Access MDB file from SharePoint

Posted on 2009-07-05
7
1,119 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
  • 4
  • 2
7 Comments
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
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
Comment Utility
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
Comment Utility
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 15

Accepted Solution

by:
dp_expert earned 500 total points
Comment Utility
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
Comment Utility
Thanks so much!
0
 
LVL 2

Author Comment

by:jrogersok
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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.

728 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

11 Experts available now in Live!

Get 1:1 Help Now