back up

[warfareian]

how do you make access save itself, and then copy itself to another area
(e.g. to a floppy disk)

 

[John Vinson]

how do you make access save itself, and then copy itself to another area
(e.g. to a floppy disk)

Are you trying to save Access, the program? You'll need a CD not a
diskette.

If (as seems likely) you're trying to back up a .mdb file database,
you can do either of two things:

- Close Access and use Windows Explorer to copy the .mdb file. An open
database should NEVER be copied, that can irreversibly corrupt it.

- Or, have Access open but close the database. Select Tools...
Database Utilities... Compact and Repair Database. Select the database
to copy, and when asked for the output database, navigate to your A:
drive or the selected backup location.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Eric Schittlipz]

how do you make access save itself, and then copy itself to another area
(e.g. to a floppy disk)

There is no built-in way, but at its simplest you simply copy the .mdb file.
However, you should only copy the file while it is not in use - so a common
approach would be to split the database into two parts: front end and back
end. The back end contains the data (just the tables) and the front end
contains the forms, reports, coding, etc. Your application (the front end)
should check whether anyone is using the back end and if not, copy the whole
..mdb to another location.
You could add a number of bells and whistles to this routine by, for
example, compacting and then zipping the file.