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.

5 Years
Discussion Span
Last Post by Formby
Featured Replies
  • 1

    Use [URL="http://msdn.microsoft.com/en-us/library/system.windows.forms.savefiledialog.aspx"]SaveFileDialog[/URL] to select a location and [URL="http://msdn.microsoft.com/en-us/library/system.io.file.copy.aspx"]File.Copy[/URL] to copy the mdb file. Read More


Thanks for the help, it worked perfectly.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.