 | |
#21
 
| |||
| |||
|
Re: VBA - batch file -
05-24-2011
, 07:39 AM
|
On 23/05/2011 16:18:02, "bsn" wrote: "Phil" <phil (AT) stantonfamily (DOT) co.uk> skrev i en meddelelse news:irdpnv$ppo$1 (AT) speranza (DOT) aioe.org... On 23/05/2011 12:54:17, "bsn" wrote: Well if I type ?shellwait("C:\Phil Data\Access\MDB 2010\Decompile ProgressMeter.bat",vbhide) in the immediate window, it works fine Did ur batch file contain a FTP job, calling a scriptfile...??? Bjarne No Just a straightforeward decompile instruction Copy "C:\Phil Data\Access\MDB 2010\Progress Meter.accdb", "C:\Phil Data\Access\MDB 2010\Decompile Progress Meter.accdb" "C:\Program Files (X86)\Microsoft Office\Office14\MSACCESS.EXE" "C:\Phil Data\Access\MDB 2010\Decompile Progress Meter.accdb" /decompile Echo "Compile DB, then compact it" Can't see what is in the batch file should make any difference, if it runs OK from the desktop. If you change the "vbHide" to "vbNormalFocus", you shouls see the DOS box ie ?shellwait("C:\Phil Data\Access\MDB 2010\Decompile ProgressMeter.bat",vbNormalFocus) |
"Error starting scriptfile bufile.txt"
I think maybee its the rights to the file bufile.txt...
But I will use the fileless version...:-)
Thx for ur patience...
Bjarne
#22
| |||
| |||
|
|
"bsn" <bsnSNABELAoncableDOTdk> wrote in message news:4dda77bb$0$56771$edfadb0f (AT) dtext02 (DOT) news.tele.dk... [] Ok... Maybee I come back to the subject later... In the meantime I found, and use this solution - it dont depend on any files... FTP directly from Access... http://www.tek-tips.com/viewthread.c...1073963&page=1 Thx a lot Phil for helping... Bjarne You could also give this a try. Does more than copy files, should you need it to... http://www.smccall.demon.co.uk/Downloads.htm#FTPClient |
Bjarne
#23
| |||
| |||
|
|
"Phil" <phil (AT) stantonfamily (DOT) co.uk> skrev i en meddelelse news:ire0t0$enk$1 (AT) speranza (DOT) aioe.org... On 23/05/2011 16:18:02, "bsn" wrote: "Phil" <phil (AT) stantonfamily (DOT) co.uk> skrev i en meddelelse news:irdpnv$ppo$1 (AT) speranza (DOT) aioe.org... On 23/05/2011 12:54:17, "bsn" wrote: Well if I type ?shellwait("C:\Phil Data\Access\MDB 2010\Decompile ProgressMeter.bat",vbhide) in the immediate window, it works fine Did ur batch file contain a FTP job, calling a scriptfile...??? Bjarne No Just a straightforeward decompile instruction Copy "C:\Phil Data\Access\MDB 2010\Progress Meter.accdb", "C:\Phil Data\Access\MDB 2010\Decompile Progress Meter.accdb" "C:\Program Files (X86)\Microsoft Office\Office14\MSACCESS.EXE" "C:\Phil Data\Access\MDB 2010\Decompile Progress Meter.accdb" /decompile Echo "Compile DB, then compact it" Can't see what is in the batch file should make any difference, if it runs OK from the desktop. If you change the "vbHide" to "vbNormalFocus", you shouls see the DOS box ie ?shellwait("C:\Phil Data\Access\MDB 2010\Decompile ProgressMeter.bat",vbNormalFocus) I have tried this - gives the same error... "Error starting scriptfile bufile.txt" I think maybee its the rights to the file bufile.txt... But I will use the fileless version...:-) Thx for ur patience... Bjarne |
Does your scriptfile use the database you are calling it from, in which case
there could be a problem. If you are, might be worth trying to run the batch
file on a copy of your Db. Otherwise, I'm stumped
Phil
#24
| |||
| |||
|
|
On 24/05/2011 13:39:38, "bsn" wrote: "Phil" <phil (AT) stantonfamily (DOT) co.uk> skrev i en meddelelse news:ire0t0$enk$1 (AT) speranza (DOT) aioe.org... On 23/05/2011 16:18:02, "bsn" wrote: "Phil" <phil (AT) stantonfamily (DOT) co.uk> skrev i en meddelelse news:irdpnv$ppo$1 (AT) speranza (DOT) aioe.org... On 23/05/2011 12:54:17, "bsn" wrote: Well if I type ?shellwait("C:\Phil Data\Access\MDB 2010\Decompile ProgressMeter.bat",vbhide) in the immediate window, it works fine Did ur batch file contain a FTP job, calling a scriptfile...??? Bjarne No Just a straightforeward decompile instruction Copy "C:\Phil Data\Access\MDB 2010\Progress Meter.accdb", "C:\Phil Data\Access\MDB 2010\Decompile Progress Meter.accdb" "C:\Program Files (X86)\Microsoft Office\Office14\MSACCESS.EXE" "C:\Phil Data\Access\MDB 2010\Decompile Progress Meter.accdb" /decompile Echo "Compile DB, then compact it" Can't see what is in the batch file should make any difference, if it runs OK from the desktop. If you change the "vbHide" to "vbNormalFocus", you shouls see the DOS box ie ?shellwait("C:\Phil Data\Access\MDB 2010\Decompile ProgressMeter.bat",vbNormalFocus) I have tried this - gives the same error... "Error starting scriptfile bufile.txt" I think maybee its the rights to the file bufile.txt... But I will use the fileless version...:-) Thx for ur patience... Bjarne Last thought Bjarne Does your scriptfile use the database you are calling it from, in which case there could be a problem. If you are, might be worth trying to run the batch file on a copy of your Db. Otherwise, I'm stumped |
I tried to copy another database...the same error appears...
But still it works if I click on the bat file on the desktop...despite of
the database are open...
I'm stumped in the problem to - so I'm satisfied with my fileless FTP'ing...
Bjarne
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.