?
Solved

Copy database button

Posted on 2008-10-28
18
Medium Priority
?
238 Views
Last Modified: 2013-12-20
I need to add a button to the main form of my database that will prompt a user for a location and then copy the database to that location.  This is a reporting database and the data is only updated once a month.  The button will allow a user to view the reports when not connected to the network.
0
Comment
Question by:astina
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 9
18 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22821380
what do you mean by copy the database? copy the whole database where your main form is?  sorry, cannot copy an open file..

please be specific as to what you want copied.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22821411
you can create a backup copy of your db.

File>Back up datqabase

this will prompt you for a location to save the backup
0
 

Author Comment

by:astina
ID: 22821746
I actually need a full copy of the database even if i have to use code to somehow close and reopen the db.  

Is there code to use the backup option?  It sounds like that might do the same thing.  Basically I need to allow the user to put the database (.mdb file) onto a flash drive to be used on a plane, train, ect.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22821796
just use the File > Back up database, no need for the codes
0
 

Author Comment

by:astina
ID: 22821987
I do not see the File > Back up option on my file menu. ??
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22822470
are not seeing this


BackUP.jpg
0
 

Author Comment

by:astina
ID: 22823179
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22823342
oh.. you are using A2000
do you want to do this using another small db application.
0
 

Author Comment

by:astina
ID: 22823735
As long as I can make it "transparent" to the user...lol.  This should allow the user to execute from the main form and copy or backup to a location that the user selects.
0
 

Author Comment

by:astina
ID: 22829879
I created a vb app to copy the app to another program.  I said access denied.  Any thoughts?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22830067
copy the app to another program ?
0
 

Author Comment

by:astina
ID: 22830214
Sorry...to another location...but did not work when the db was open.  Worked fine when it was closed.  Windows can copy an open db (when you right click > copy).
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22830778
is the db application an .mde or .mdb?
0
 

Author Comment

by:astina
ID: 22831328
.mdb
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 22831877
check this small .mdb
CopyDBFileApp.mdb
0
 

Author Comment

by:astina
ID: 22832875
That's a great little mdb....i will certainly use that in the future.  It does not work for this because will not copy a db that is open by another user.
0
 

Author Comment

by:astina
ID: 22832911
Is there a way we can make windows ignore that the file is open?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22833829
i already mentioned about copying an open file at http:#a22821380

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month10 days, 8 hours left to enroll

765 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