How do I make a complete copy of my Access DB in sql / Ado

[KenniM]

I need to make a complete copy af an Access Database using SQL and ADO. I can get this to work while only copying the Tables, but i need the MSys tables too in order to get all information - relationships and so on.

So if anyone know how to copy ALL tables, views, Msys from one database, using SQL / ADO (or something else), to a new one please respond. Thanks!

 

[mp9]

Is there some technical reason why you can't just copy the MDW file in Windows Explorer?

http://www22.brinkster.com/accessory/

 

[KenniM]

If for some reason the database gets corrupt or fails in some way, most of these errors can be dealt with by replicating the database or re-creating the fields that are making problems. So if an error is encountered the web-application will first try to solve this by doing the replication and so on.