Thank you debasisdas,

But, I don't seem to be reading your suggested code correctly.

1. Say the database is named DATA.mdb, and has 2 Tables in which we write values for every 30 seconds but we write them every 5 minutes.

2. The db could have some data from last July up to now

3. I want to have the data from July written or copied or moved to a db named Data.mdb in the sub-directory named...

I have this data acquisition program, writing to an Access database every minute. The link between the two is through an ODBC User data source.

The database gets bigger and bigger.

I would like to copy the database to a dir named after the year and month... Ex: .../2007_march AND THEN clear the actual database to make room for the newer data.

My first problem comes from my poor very English vocabulary....