Back Up Database in Ms Access 2010

[Mehvan]

Hello Everyone

How can We do back up database in Ms Access 2010 to inside database project ?

We can do back up to any place we want on PC , but I would like to do back up to inside our project and When We want We be able to get it in easy way



And When We want to make empty for our project at the end of the year , that be on project and we be able to return it When We want .

[isladogs]

OK, you want to make a BACKUP. What does 'inside our project' mean?

You can do a backup by doing File ... Save Database As
Or it can be done from a button click using code

[Mehvan]

Sorry, My English isn't very good

for Example : When I'm doing File , Can I choose an Access Project ?

Such as : When We choose a photo from Laptop , We will save it in Table as "Attachment"

[isladogs]

I thought you wanted to make a backup copy of your database....

Your last post suggests you want to save a file e.g a photo using the attachment datatype.
As I never use it, I can't assist.
However I strongly recommend you don't do this either as it will cause your database to grow rapidly.
Performance will suffer and eventually your fb will reach the 2GB limit and be unusable.

A much better method is to use a text field contain the file path
You can then view the photo in Access using an image control

[Mehvan]

thanks a lot for your advice ridders52

yes , Microsoft Access can't save a big data , because we can use Ms Access for a small project not a big project
When We want to build a big project by Ms Access , it will be slowly When we are using or When We want to connect with other PC
I mean When We Shared Ms Access project with 5 PC or more , We will feel our project is working slowly .

[isladogs]

Hi Mehvan
Not quite sure what you mean.
What is your first or main language?

[Mehvan]

I'm Kurdish From Kurdistan region
My native language is Kurdish ,, so that my English language isn't very good

[isladogs]

Hi Mehvan
Îngilîzî ji min re çêtir e ku ji min re biaxivim.
Lê ez dizanim ku çawa wergera Google wergera ku ez niha dikim.
Ez pêşniyar dikim ku hûn hewl bikin ku şîroveka xwe bi kurdî re nivîsîn, wergera xwe werger û şandina peyda bikin.


Ew nikare bêkêmahî lê lê dibe ku ew alîkarî bike.

[Mehvan]

bele ez ji te fem dikim
Yes , I can understand you well , but sometimes gives us mistake meaning
Is your native language English ?

[isladogs]

Baş. Ew dikare di pêşerojê de alîkarî bike.
Erê, ez axaftina Îngilîzî im