Downloading data

Copper Contributor

Is there a way for me to download my data into a thumbdrive to keep as backup??

2 Replies

@janetbrunette 

Yes, make a copy of the accdb containing the data onto the thumbdrive.

 

But, here's a bit of background on best practices for Access relational database applications, as well.


Access applications should be split into two accdbs.

 

One, usually referred to as the "Front End" or FE, contains only the forms, reports, queries and code.

The other, usually referred to as the "Back End" or BE, contains on the tables with the data.

 

The FE links to the tables in the BE. 

 

That allows you to modify or replace the FE as needed without having to worry about the data in the BE.

 

In your case, you can make a backup of the BE on the thumbdrive, although you might want to occasionally include the FE if  and when it's modified.

 

 

You should make frequent backups, probably daily for most relational database applications. More often if it is heavily used and a lot of transactions are being entered.