Re: Backup of Database

I would just copy it in Windows Explorer. I've never used the backup
command within Access.

--
Joan Wild
Microsoft Access MVP
"FIECA" <tom.pratt@xxxxxxxxxxx> wrote in message
news:OZloWIvSHHA.4632@xxxxxxxxxxxxxxxxxxxxxxx
Joan,

I am using the "Backup Database" function under "Tools->Database
Utilities" on the standard Access menu.

"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message
news:uetpCCvSHHA.5068@xxxxxxxxxxxxxxxxxxxxxxx
How are you doing the backup? I just use Windows Explorer and make a
copy of the file. That shouldn't change its size at all.

--
Joan Wild
Microsoft Access MVP
"FIECA" <tom.pratt@xxxxxxxxxxx> wrote in message
news:%23kAdmsuSHHA.1200@xxxxxxxxxxxxxxxxxxxxxxx
Here's a question I hope someone can help me with. Since I am
constantly updating my database, making changes to it, I create backup
copies before major changes, so that if the changes backfire on me, I
can go back to the previous version. However, when I make the backup
copy, the backups are invariably smaller that the "main" database file.
If it was only a negligible amount I woudln't sweat it, but we are
talking some major size differences here. For instance, I backed up my
52Mb database, and the backup file was only 28Mb. Should I be concerned
about this? Does anyone know why? I just want to make sure I am not
losing anything. So far I cant find where any of my data, forms,
reports or queries are missing, so I am assuming that there is another
explanation. I was thinking that the backup copy is somehow compacted,
but I run the "compact and repair database" tool pretty frequently.
Anyway, I am dumbfounded at how this happens. I just want to make
double sure that the backup I am creating is in fact a complete
duplicate of the original, otherwise I may be shooting myself in the
foot. Any help would be greatly appreciated.

Thanks,

Tom Pratt







.

Relevant Pages

  • Re: Paste append rows from table on CD
    ... "John Nurick" wrote: ... make certain you have a current backup of your database. ... These databases are identical as the CD is a backup copy of my daily work. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • Re: lost the data on changing the field type from text to date/tim
    ... Is there a way I can auto backup my database every night? ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: Locked myself out
    ... and fully understand the Access Security Faq from microsoft.com. ... Microsoft Access MVP ... Can you restore a backup? ... Everytime I open the database it says I don't have permission to ...
    (microsoft.public.access.security)
  • Re: Spurious Database Creation
    ... Here is an article about LDB files: ... Microsoft Access MVP ... Now, I am noticing that on our share disk, where several Access Databases ... I put the backup databases in a separate drive, and I make sure the .ldb is ...
    (microsoft.public.access.security)
  • Re: New module prevents further design changes
    ... I doubt very much that it's related to the code from "The Access Web": ... Doug Steele, Microsoft Access MVP ... (no e-mails, please!) ... I do have a backup copy so ...
    (microsoft.public.access.modulesdaovba)