Thread View: borland.public.cppbuilder.database.ado
4 messages
4 total messages
Started by Stev
Wed, 29 Nov 2000 06:30
ACCESS Database Compression?
Author: Stev
Date: Wed, 29 Nov 2000 06:30
Date: Wed, 29 Nov 2000 06:30
2 lines
936 bytes
936 bytes
how can i compress the access database to delete the unused data and cut down on the size??
Re: ACCESS Database Compression?
Author: Greg
Date: Wed, 29 Nov 2000 17:50
Date: Wed, 29 Nov 2000 17:50
15 lines
1442 bytes
1442 bytes
Although ADO specification does not provide objects to compact or repair Microsoft Access databases, this capability can be achieved by using the ADO extension: Microsoft Jet OLE DB Provider and Replication Objects (JRO). This capability was implemented for the first time in the JET OLE DB Provider version 4.0 (Msjetoledb40.dll) and JRO version 2.1 (Msjro.dll). These DLL files are available after the install of MDAC 2.1. "Stev" <stevr_326@hotmail.com> wrote in message news:3a24a1c6_1@dnews... > how can i compress the access database to delete the unused data and cut > down on the size?? > > > > > >
Re: ACCESS Database Compression?
Author: Jerry Bloomfield (TeamB)
Date: Thu, 30 Nov 2000 03:40
Date: Thu, 30 Nov 2000 03:40
16 lines
1520 bytes
1520 bytes
On Wed, 29 Nov 2000 08:30:08 +0200, "Stev" <stevr_326@hotmail.com> wrote: >how can i compress the access database to delete the unused data and cut >down on the size?? I have an entry in Code Central which does this using the ODBC API. You should be able to find it at: http://codecentral.borland.com/codecentral/ccweb.exe/author?authorid=318 (I think it is the top entry). Jerry Bloomfield (TeamB) -- http://www.teamb.com JersWork@wwa.com Please do *NOT* send private e-mail without prior permission (my anti-spam filters will probably just delete it anyway <g>)
Re: ACCESS Database Compression?
Author: Greg
Date: Fri, 01 Dec 2000 22:30
Date: Fri, 01 Dec 2000 22:30
30 lines
1690 bytes
1690 bytes
Although ADO specification does not provide objects to compact or repair Microsoft Access databases, this capability can be achieved by using the ADO extension: Microsoft Jet OLE DB Provider and Replication Objects (JRO). It has a CompactDatabase method. This capability was implemented for the first time in the JET OLE DB Provider version 4.0 (Msjetoledb40.dll) and JRO version 2.1 (Msjro.dll). These DLL files are available after the install of MDAC 2.1. "Stev" <stevr_326@hotmail.com> wrote in message news:3a24a1c6_1@dnews... > how can i compress the access database to delete the unused data and cut > down on the size?? > > > > > > "Stev" <stevr_326@hotmail.com> wrote in message news:3a24a1c6_1@dnews... > how can i compress the access database to delete the unused data and cut > down on the size?? > > > > > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads