Update or Append

[BartK]

Hi all,
Had limited experience with queries, I am basically wanting to ensure that my backup database is as up to date as the one I am currently using in the event something happens with that file.

What type of query do I use? I would think that I would use an update query as I would like to update all records in my one table to the other, from time to time records are deleted and quite frequently I do add records to it. Am I correct in assuming this is the way to accomplish what I am wanting to do. Thanks in advance

 

[plog]

I vote neither. Copy the entire file everyday/half day/hour/ etc.. You can write a batch script and have that run automatically using windows scheduler.

 

[Mihail]

Hi
My first guess was to silent subscribe to this thread.
But I have too a question on the backup subject.
My question can be also an answer for you.

Why to backup a DB by using complicate (more or less) code when I can to make a copy by using Windows Explorer ?

Thank you !

 

[Mihail]

Seems that plog answered to my question in time that I write it

 

[BartK]

Batch script?? Is that something in Access or something else? I'm using a company computer and I doubt they would let me do something outside my permissions. Thanks

 

[Mihail]

Batch script?? Is that something in Access or something else?

Is something else
But this is in Access.

Create a button from where to run the code or use the TIMER event in order to simulate a "scheduler".
Name your file by using the date:
FileName = YourFileName & Now()

 

[plog]

If you can right click a file, copy it and then paste it somewhere you have privileges to run a batch file. When you do those actions to copy/paste a file you are essentially giving the operating system commands. A batch file is just written out commands. Check out this link:

http://en.wikipedia.org/wiki/Batch_file

 

[BartK]

So it looks like a batch file is definately above what i know. I guess I will have to find aother way to back up my table. Thanks everyone.