Try writing a batch file that does what you want, then just cfexecute that
instead, I have more luck doing it that way.
Craig.
-Original Message-
From: Terry Troxel [mailto:[EMAIL PROTECTED]]
Sent: 07 October 2002 16:19
To: CF-Talk
Subject: CF execute HELP
I have never used cfexecute before and could use a few pointers
before I suffer early hair loss.
Here is what I am attempting to do.
I would like to run Access from the command line opening
a database with a linked table in it that will be copied to another
datasource using an autoexec macro which has a copy object
call as it's action.
The reason I am doing this is my financial package (MAS90) uses
illegal characters in its database table naming that Access can handle,
but not CF. So I am attempting to create a new table everytime I open
the test.mdb. It works fine in windows 2000, but not in a CF template
using the following parameters. This is an intranet app.
cfexecute name = C:\program files\microsoft office\office\msaccess.exe
arguments = c:\inetpub\databases\test.mdb
timeout = 100
/cfexecute
If anyone can show me the correct method to accomplish my task
I would greatly appreciate it.
Terry
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm