Solved

Open access using a command line exclusive as a hyperlink

Posted on 2011-03-23
7
361 Views
Last Modified: 2012-05-11
I am using Microsoft Expression Web 3 and Access 2003, 2007.  I am opening a database from a page with a hyperlink with the path of the database.   I want to open the database exclusively but it does not allow the /excl paramater.  

e.g.  c:\database.mdb

I have tried using a batch file but it opens the batch file in edit mode from the web page.  The batch file will work when I double click on it from explorer.

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" c:\database.mdb /excl    
0
Comment
Question by:cc22
  • 4
  • 3
7 Comments
 
LVL 2

Expert Comment

by:IT-Factory
ID: 35200112
execute as """c:\database.mdb""" /excl

watch the "
0
 

Author Comment

by:cc22
ID: 35200185
This is the actual address on the hyperlink page:  file:///c:/database.MDB

Where do I put the quotes?
0
 
LVL 2

Expert Comment

by:IT-Factory
ID: 35200253
use a cmd file

in database.cmd put c:\database.mdb /excl

then start file://c:\database.cmd
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Author Comment

by:cc22
ID: 35200645
file:/o:/cognos/batch/quotes.cmd  - opens command file in edit mode

command file executes when I double click on it

o:\cognos\corporate\database\custquotes.mdb /excl  

0
 
LVL 2

Expert Comment

by:IT-Factory
ID: 35201375
why do you want to use the link via the address bar? Is a button on a html page also ok?
0
 
LVL 2

Accepted Solution

by:
IT-Factory earned 500 total points
ID: 35201386
does this help?

<html>
<input type=button value="Open Quotes" onclick="launch('o:\cognos\corporate\database\custquotes.mdb /excl')">
</HTML>
<script language="Javascript">
function launch(sApp) {
window.open(sApp,...)
}
</script>
0
 

Author Comment

by:cc22
ID: 35201394
A button is o.k.  I am using it in a menu that I have that is also linking to excel reports.  When I do I search for the database it put the prefix 'FILE:' in front of the database.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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…

776 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