Article View: borland.public.cppbuilder.database.ado
Article #2370Re: Advice Please - ADO Archiving
From: Andrew
Date: Fri, 05 Sep 2003 13:36
Date: Fri, 05 Sep 2003 13:36
24 lines
1894 bytes
1894 bytes
Many thanks Viatcheslav, That works perfectly and is far quicker than my current method. Andrew. "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message news:3f587dfa$1@newsgroups.borland.com... > Save backups into another Access database, or even you may have one database > for every month. Then when your user needs older records you do > > SELECT * FROM MyTable IN "C:\Backups\2003_04.mdb" > UNION > SELECT * FROM MyTable IN "C:\Backups\2003_05.mdb" > > Do not forget to compact database when you place it into backup. > > ---------------------------------------------------------------- > Regards, > Viatcheslav V. Vassiliev > http://www.oledbdirect.com > The fastest way to access MS SQL Server, MS Jet (MS Access) > and Interbase (through OLEDB) databases.
Technical Details
Message-ID:
<3f58916d@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3f584ba5@newsgroups.borland.com> <3f587dfa$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,94a848929fea2f7a X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-09-05 06:39:50 PST From: "Andrew" <alamb@tynetec.co.uk> Newsgroups: borland.public.cppbuilder.database.ado References: <3f584ba5@newsgroups.borland.com> <3f587dfa$1@newsgroups.borland.com> Subject: Re: Advice Please - ADO Archiving Date: Fri, 5 Sep 2003 14:36:03 +0100 Lines: 27 Organization: Tynetec Ltd X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 80.177.44.179 Message-ID: <3f58916d@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1062769005 80.177.44.179 (5 Sep 2003 06:36:45 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail