Solved

Backup a msacces database with savedialog

Posted on 2014-01-24
2
134 Views
Last Modified: 2014-01-24
Dear Experts,

I want to write code to give the user the ability to create a backup of an access database by pressing on a button. Must I disconnect first and then connect the database after making the copy or can I just use a file copy methode?

Greetings, Peter Kiers
0
Comment
Question by:peterkiers
2 Comments
 
LVL 44

Accepted Solution

by:
AndyAinscow earned 500 total points
ID: 39806450
A simple filecopy will suffice BUT if a user is in the process of writing (possibly reading)  then it will very likely fail.  Safest is for all users to stop using the database before making the copy.
0
 
LVL 1

Author Comment

by:peterkiers
ID: 39807293
Oke thank for the advice. Peter
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now