Query Qutomation

[Puddy]

I'm hoping that this can be done, but from the reading I've done, haven't seen anything that can do it yet. Currently a one of my users has an access db that runs about 7-8 append queries on data that it has brought in from our AS/400 system. There is alot of data and the queries take a long time to run, up to 3-4 hours. The user would like to automate this process to run over night, which is no big deal for me to do. However, the append queries need input from the user on a start date and end date to run. My question is whether or not there is a way to have the input dates put in once and then carried over to the other queries...

Thanks

 

[simongallop]

Build a form with 2 unbound textboxes. Place the data there and get the queries to refernce the form.

What are they doing to last 3-4 hours?? If you are dealing with that amount of data then shouldn't you be using something more powerful ie Oracle / SQL Server etc?

 

[Puddy]

That's on my project list, to get this db into SQL...this db was already here when I got here...now I have the chore of building it in SQL...

 

[simongallop]

Perhaps I am wrong but thought that it was meant to be easy to export tables and queries to SQL

 

[Rich]

Why 3-4 hrs, how are you appending the data?