Can you use Scheduler on secured database?

I

icq_giggles

Can I set up an automatic update on a secured database? If so how?

I have two updates that need to be run, on is ran from a module, one from a
macro.
 
K

Klatuu

Yes, you can use command line startup options in the task scheduler to pass
a user name and password to the application.
 
I

icq_giggles

Thank you for responding.

I would need some direction on how to do that. Please?
 
K

Klatuu

Open Access Help and search on Command Line Options. You will find the
options and how to use them there.
 
I

icq_giggles

Great - found that portion I guess my real problem is setting up the script
syntax to open the database with the security file. I'm using Albert
Kallal's batch script but I keep getting an error that the database is either
missing or opened exclusively by another user - of which it is neither. I've
put in the username and password switches but still get the same error.
 
I

icq_giggles

I've changed some names due to sensitivity issues but this is what I
currently have:

dim accessApp
dim acpath
dim dbloc
dim secfile
dim uname
dim pwd
acpath = "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
dbloc= "'C:\Documents and Settings\me\my documents\mydb.mdb'/wrkgrp"
secfile = "I:\Project\abcd\123\dddd\se\dept\ffolder\security1.mdw"
uname = " /user 'myusername'"
pswd = " /pwd 'mypwd'"
filename = (acpath&" "&dbloc&" "&secfile)
set accessApp = createObject("Access.Application")
accessApp.OpenCurrentDataBase (filename&uname&pswd)

accessApp.Run "mymodulename"
accessApp.Quit
set accessApp = nothing
 
Top