replacing tables in access

[dan graziano]

Hi,

I currently have a five table and query system created in access.
Basically the structure is fixed. But I have to run the query over
numerous times using different updates of the tables.

Four of the tables need to be replaced before I redo each query run.
Rather than importing each of the four tables individually each time
before I do a run, is there some way that I could just put all the
tables per run in some folder and create a macro that will automatically
replace each of the access tables with the corresponding update tables
in the folder?

It would be good to be able to do this as I'll have to run this same
query very many times, and it would be good to be able to replace all
the tables in one shot.

Thanks.

Dan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tom van Stiphout]

On 14 Oct 2004 22:28:46 GMT, dan graziano <d3********@hotmail.com>
wrote:

If referential integrity is not an issue in your app, DoCmd.Transfer*
may be your friend.

-Tom.

Hi,

I currently have a five table and query system created in access.
Basically the structure is fixed. But I have to run the query over
numerous times using different updates of the tables.

Four of the tables need to be replaced before I redo each query run.
Rather than importing each of the four tables individually each time
before I do a run, is there some way that I could just put all the
tables per run in some folder and create a macro that will automatically
replace each of the access tables with the corresponding update tables
in the folder?

It would be good to be able to do this as I'll have to run this same
query very many times, and it would be good to be able to replace all
the tables in one shot.

Thanks.

Dan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[dan graziano]

Tom,

Thanks again for the reply. I'm afraid I'm a real newbie to this, how
would DoCmd.Transfer* work - is this a code I need to create?

In fact, is sql or visual basic macro a possible way to do this?

Thanks for the clarification.

Dan
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!