Want to copy Access database to disk Where is it

[Guest]

I want to save my database I just created so I don't have to re-enter my data
should something happen to the file. Should I copy more then one file when I
copy the database?

 

[Rob Parker]

Everything in your database (all tables, queries, forms, report, etc) is
stored in a single file, with a .mdb extension (or perhaps .accdb if you're
using Access 2007). The only exception is if you've split your database
application into front-end/back-end parts, in which case the data is stored
in the back-end file only. But from your question, I suspect that you're
not doing that yet ;-)

And congratulations for thinking about, and doing, backups!

HTH,

Rob

 

[Guest]

Rob...

Thank you very much for your help! I have now copied my database to a disk.
Before I retired I would have known how to do this; however, I have been
retired since 2002 and I don't keep up with things as I did before I retired.
After you gave me the answer I remembered. And as for backups, this is one
thing I stressed over and over again when I was working. A lot of people
didn't take heed my warning and some lost valued information that took a long
time to enter.

Thanks, again!