Can you use Scheduler on secured database?

  • Thread starter Thread starter icq_giggles
  • Start date Start date
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.
 
Yes, you can use command line startup options in the task scheduler to pass
a user name and password to the application.
 
Thank you for responding.

I would need some direction on how to do that. Please?
 
Open Access Help and search on Command Line Options. You will find the
options and how to use them there.
 
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'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
 
Back
Top