?
Solved

Open access using a command line exclusive as a hyperlink

Posted on 2011-03-23
7
Medium Priority
?
377 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

752 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