rosalyn.clarke at barclays.com
rosalyn.clarke at barclays.com
Mon Jun 23 10:39:11 CDT 2008
I know, I was just trying to cover the 'user wants to select records and there's no rule about which ones to archive' scenario, whilst allowing use of a simple SELECT INTO. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: 23 June 2008 16:32 To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- 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.