Put a copy of access in another folder

[SA]

Hi all,
I wanted to make a read only copy of an access database every night and put
it in a different folder. Is this doable from within access or would I just
have to write a script for this?

Thanks,
SA.

 

[Dean]

Since Access uses VBA, you can write code that does just about anything you
want. You won't be able to copy the open database but you can have another
Access file that contains your maintenance code for working with other DBs.

 

[SA]

Thanks Dean.

Since Access uses VBA, you can write code that does just about anything
you want. You won't be able to copy the open database but you can have
another Access file that contains your maintenance code for working with
other DBs.

 

[aaron.kempf]

but it's a LOT easier to use ACCESS DATA PROJECTS; you can schedule a
complete backup; store backups for 4 weeks; and do it every night at
2am.. you can schedule this without writing anything.

good luck in choosing the best architecture in the future.

ADP with MSDE or SQL Server.