954,535 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Backup Access Database in VB.NET

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.

Formby
Newbie Poster
10 posts since Apr 2011
Reputation Points: 10
Solved Threads: 0
 

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

Momerath
Nearly a Senior Poster
3,386 posts since Aug 2010
Reputation Points: 1,232
Solved Threads: 558
 

Brilliant!
Thanks for the help, it worked perfectly.

Formby
Newbie Poster
10 posts since Apr 2011
Reputation Points: 10
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: