How to copy a .mdb file and rename it?

[Ali Rizwan]

Hey
Can some body help me to copy a .mdb file and rename it after a month automatically.
and how to empty some records in database daily.

Thanks i need it badly.

[pureenhanoi]

Hey
Can some body help me to copy a .mdb file and rename it after a month automatically.
and how to empty some records in database daily.

Thanks i need it badly.

Use Timer to manually schedule the jobs. Timer cannot archive interval as much as you want, so you must use some Varriables for counting. Maybe, with this type of job, you just need check once each hour.

[Killer42]

Can some body help me to copy a .mdb file and rename it after a month automatically. and how to empty some records in database daily.

I think we need more details on what you're using (Access VBA, standalone VB, or what? What version of Access?) and what you're trying to achieve. And which part of it you really need help with.

If you just want to run a program once a month, use the Windows scheduler to start it. Or is this a program which runs all the time, or what?

[hariharanmca]

Hey
Can some body help me to copy a .mdb file and rename it after a month automatically.
and how to empty some records in database daily.

Thanks i need it badly.

If you explain your requierment we can give better solution. Will you?

[Ali Rizwan]

If you explain your requierment we can give better solution. Will you?

Thanks for reply.
Actually i am making an application for a school. In which in teachers attendance record i want to copy the monthly attendance database to a specific location. And wnat to empty record from daily attendance record.
I used fso.copyfiles but it gives me an error and does not copy files.
What can i do now.
I am using ADODC to bind data.

[Ali Rizwan]

Use Timer to manually schedule the jobs. Timer cannot archive interval as much as you want, so you must use some Varriables for counting. Maybe, with this type of job, you just need check once each hour.

Thanks for reply.
i do this too but the error is in copying files.
in fso.copyfile
can you tell me please how to rename it.

[Killer42]

... I used fso.copyfiles but it gives me an error and does not copy files.

What error?

[Ali Rizwan]

What error?

Thanks a lot for reply.
But i have found my mistake by the help of you so i want to thank you again.
Best wishes Killer