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.

Recommended Answers

Use SaveFileDialog to select a location and File.Copy to copy the mdb file.

Jump to Post

All 2 Replies

Thanks for the help, it worked perfectly.

Be a part of the DaniWeb community

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