Hi Amy,
Why not use Append Queries. Example of SQL Syntax:
INSERT INTO [BackUp]
SELECT [Main Table].*
FROM [Main Table];
When you would run it depends on how your application is structured for
your users (e.g., at the end of the day, while working in a Form, etc..)
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| Content-Class: urn:content-classes:message
| From: "Amy Johnson" <
[email protected]>
| Sender: "Amy Johnson" <
[email protected]>
| Subject: Back up Table
| Date: Tue, 27 Apr 2004 14:57:07 -0700
| Lines: 10
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcQsopUxE5YJ5WpmQMGtT3UZrZQ0tQ==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:78677
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Is there a way to have one table (for example I will call
| Main Table) and backup (I'll call Backup). What I need to
| happen is when records are added to the Main Table I want
| it to be added to the back up. Here is the catch. When
| information is deleted from the Main Table I do not want
| it deleted from the Backup Table.
|
| Any Ideas????
|
| Thank You
|
