asked on

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!

ASKER CERTIFIED SOLUTION

James Murrell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Senniger1

ASKER

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?

Senniger1

ASKER

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.

Senniger1

ASKER

Thank you so much. This was exactly what I needed.