Improve company productivity with a Business Account.Sign Up

x
?
Solved

Create shortcut in SharePoint WSS to open Access 2003 database

Posted on 2009-05-08
4
Medium Priority
?
633 Views
Last Modified: 2012-06-27
We currently have SharePoint WSS 3.0 and MS Access 2003.
I have several Access databases which have multiple tables, forms, etc.  At this time I'd like to just create a link or icon or something in Sharepoint which will just replace the desktop icon we currently use to open the database.
I can't find any way to do this since everything points to publishing with Access (which is for Access 2007) or importing or linking tables.
At this time I only want to use Sharepoint to let them open the database.
Can anyone help!
Thanks!
0
Comment
Question by:Senniger1
  • 3
4 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 2000 total points
ID: 24350111
Start in Notepad with the following:

"C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" to open Access on your PC.  Just find the path to the program; hopefully it's standard on everyone's PC.

Save it as a .bat file  (example:  openaccessinwwss.bat) on your shared directory.

Put a shortcut or link to openaccessinwwss.bat in WSS
0
 

Author Comment

by:Senniger1
ID: 24358454
I created a .bat file and below is it's content:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "W:\Customer.mde" /wrkgrp "W:Customer.mdw"

My only problem is the DOS Black Window stays open until I exit the database.  I'd like to open the database, then close the DOS window.

Do you know of a way to prevent the black window from showing?
0
 

Author Comment

by:Senniger1
ID: 24388620
I figured out how close the DOS window.
Basically I added this...
start "" 
In front of my file path below...
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "W:\Customer.mde" /wrkgrp "W:Customer.mdw"
Resulting in this...
start "" "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "W:\Customer.mde" /wrkgrp "W:Customer.mdw"
And my DOS windows closed.

0
 

Author Closing Comment

by:Senniger1
ID: 31579391
Thank you so much.  This was exactly what I needed.
0

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
I recently worked on a Wordpress site that utilized the popular ContactForm7 (https://contactform7.com/) plug-in that only sends an email and does not save data. The client wanted the data saved to a custom CRM database. This is my solution.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

595 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