Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 631
  • Last Modified:

Create shortcut in SharePoint WSS to open Access 2003 database

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
Senniger1
Asked:
Senniger1
  • 3
1 Solution
 
James MurrellProduct SpecialistCommented:
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
 
Senniger1Author Commented:
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
 
Senniger1Author Commented:
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
 
Senniger1Author Commented:
Thank you so much.  This was exactly what I needed.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now