Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Open access using a command line exclusive as a hyperlink

Posted on 2011-03-23
7
Medium Priority
?
387 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
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…

598 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