[AccessD] Archiving Records

I actually have to get the records out of the db and delete them.  (JC will
have a fit:o)) 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
rosalyn.clarke at barclays.com
Sent: Monday, June 23, 2008 7:36 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Archiving Records

As a halfway house you could set an 'archive' flag in each record and use
this as the condition for your SQL statement.  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: 23 June 2008 15:02
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Archiving Records

> Is there an easy way to do this without creating a copy of each 
> records by looping through each field in the source record to create 
> the target record and then writing it to the target database?

=======The simplest way is to leave the record where it is and flag it as
active/inactive, whatever. Then, update all your queries to accommodate this
value. I realize this isn't a good solution if the problem is resources. If
resources aren't a problem, I wouldn't go to the trouble to actually move
records.

The next option is to come up with some condition -- the record's date is
usually a good one -- to use as criteria for moving the records to an
archive table -- you don't have to loop through anything, just use a SQL
INSERT INTO to "append" a recordset to an existing table -- it's the same as
an Append query. Then, use the same action with a Delete query on the
original source.

You just need some kind of anchor to identify the records you want to
archive (move).

Susan H. 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This e-mail and any attachments are confidential and intended solely for the
addressee and may also be privileged or exempt from disclosure under
applicable law. If you are not the addressee, or have received this e-mail
in error, please notify the sender immediately, delete it from your system
and do not copy, disclose or otherwise act upon any part of this e-mail or
its attachments.

Internet communications are not guaranteed to be secure or virus-free.
The Barclays Group does not accept responsibility for any loss arising from
unauthorised access to, or interference with, any Internet communications by
any third party, or from the transmission of any viruses. Replies to this
e-mail may be monitored by the Barclays Group for operational or business
reasons.

Any opinion or other information in this e-mail or its attachments that does
not relate to the business of the Barclays Group is personal to the sender
and is not given or endorsed by the Barclays Group.

Barclays Bank PLC.Registered in England and Wales (registered no. 1026167).
Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.

Barclays Bank PLC is authorised and regulated by the Financial Services
Authority.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com