Solved

Open access using a command line exclusive as a hyperlink

Posted on 2011-03-23
7
355 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article will show you how to use shortcut menus in the Access run-time environment.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
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…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

929 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now