November 27, 2006 at 12:49 pm
I am trying to see if it is possible to schedule once a month where several of my Access databases will perform there import process automatically, similar to how you can do with SQL DTS.
I do not want use timer event which would require me to leave all of the databases open. I do not want to write vb.net code, too.
Thanks,
November 28, 2006 at 1:10 am
"Simplest" way is to use the windows scheduler on a suitable machine.
Second trick is to create a "master" database which links to all your Access databases which need importing.
Third bit is use an autoexec macro to run the import routines and then quit.
Final bit, in the scheduler, create a command to run your master database. To get this to work smoothly with macros etc, you will need to lower your security so you do not get any macro warnings. If you don't want to do this, then you need to look at something like autoit at http://www.autoitscript.com/autoit3/ to script all the clicks to get you database to run properly.
November 28, 2006 at 5:40 am
'Simplest" way is to use the windows scheduler on a suitable machine-it that mean the suitable machine need to be on all the time.
Second trick is to create a "master" database which links to all your Access databases which need importing.-will you give me more detail for that.
Third bit is use an autoexec macro to run the import routines and then quit.
that is mean you need operate it like launching the database.
Thanks.
November 28, 2006 at 6:17 am
The suitable machine need to be on all the time. Yes, you can't avoid that one.
Linking to all your access databases. Suppose you have three databases d1, d2 and d3 with one table in each say t1 in d1, t2 in d2 and t3 in d3.
Create a new database, go to file, get external data, link tables. Navigate to d1.mdb and link t1, navigate to d2.mdb and link t2, navigate to d3.mdb and link t3. I'm hoping you've got the mdb files on some sort of server or permanently connected machine.
If the files have got the same name across different databases you may have to do some sort of renaming.
I don't know how you're updating the databases, presumably some sort of query or whatever. You will then need to link the relevant tables into the master database and copy the queries across or use file, get external data, import if you haven't done too much renaming.
Yes, it's exactly like opening (manually) a databse that does all the work only you use the scheduler.
November 28, 2006 at 7:33 am
Thanks. Do you know any the good web site for scheduling ?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply