I've looked all over the internet for a suitable solution to my problem, and I just can't fine a simple and effective one; so I hope I can get some help here!

First off I am programming a hotel booking system for my college computing project. This consists of a bunch of windows forms coded in Visual Basic, and an Access database stored locally. The application gets information for the forms about customers, bookings etc... from the database.

I would just like a way of making a complete copy of the database (.mdb) file and placing it into a user selected destination. Does anyone have a simple solution to this?

I would be happy using SQL to extract the data from the database and placing it into another, but I just don't know how! As I only have about 50 hours coding experience!

Any suggestions are welcome, thanks!
- Formby.

Brilliant!
Thanks for the help, it worked perfectly.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.