saveas in access

[philfer]

Hello,

I am trying to save a database in vba but having some problems.

When the user open the previous months database and enters a new run date I use a FileSystemObject to create a new folder for that date and want to then use saveas to save the database in that folder.

I have tried

Set myDB = CurrentDb
MyDB.SaveAs

but it doesnt work

Any help??

Also, I use CreateObject to create a scripting object to create the folder, how do I remove the object from memory after I'm done?

Is it just Set fso=Nothing

Cheers guys
Phil

[philfer]

Any help guys???

Cheers
Phil

[geekgirlau]

Can you explain the logic here? Why do you have to create a new database every month?