🚀 go-pugleaf

On Wed, 19 Sep 2001 11:38:34 -0700, "Shawn Lammers"
<slammers@nospam.smartire.com> wrote:

>I have a program where the user can create a new Access database. Currently
>the program just uses the windows CopyFile command to copy a blank Access
>database to the new one the user wants and then starts using it. Is there a
>way using ADO that you can create a blank database directly?
>
>Similarly, is there a way to Compress and Repair access databases through
>ADO? I have done this through Visual Basic but can not figure out how to do
>it through ADO.

I am not an ADO expert,  but I do not believe that this is currently
possible using ADO.  I know it can be done using ODBC and I am fairly
certain it can be done using OLEDB,  but I have not found a method to do
this using ADO.

For an example of doing this using ODBC,  take a look at my entries in
CodeCentral.  I have two of them,  one to create/compact/repair an MDB file
using the ODBC API,  and another to use the ODBC API to create a C++ Class
much like the VCL TQuery component (but very rudimentary).

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>)