Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Open Access MDB file from SharePoint

Posted on 2009-07-05
7
Medium Priority
?
1,186 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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 earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

610 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