astina
asked on
Copy database button
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.
you can create a backup copy of your db.
File>Back up datqabase
this will prompt you for a location to save the backup
File>Back up datqabase
this will prompt you for a location to save the backup
ASKER
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.
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.
just use the File > Back up database, no need for the codes
ASKER
I do not see the File > Back up option on my file menu. ??
ASKER
no
file.jpg
file.jpg
oh.. you are using A2000
do you want to do this using another small db application.
do you want to do this using another small db application.
ASKER
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.
ASKER
I created a vb app to copy the app to another program. I said access denied. Any thoughts?
copy the app to another program ?
ASKER
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).
is the db application an .mde or .mdb?
ASKER
.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
Is there a way we can make windows ignore that the file is open?
please be specific as to what you want copied.