Board index » delphi » Creating an MS Access DB using ADO Express/Delphi 5

Creating an MS Access DB using ADO Express/Delphi 5

Can I create a new MS Access database using the JET.40.OLE DB PROVIDER.? The
ADO Connection object or Command object
allow access to an existing database but I cannot seem to create one since
the connection object requires a database in order to
authenticate itself upon startup/initialization.

Cheers,
Scott

--
SCOTT F SKIBA
Control Master Inc.
Phone: 908-735-9002
Fax    :  908-735-8902
Email : ssk...@controlmaster.com

 

Re:Creating an MS Access DB using ADO Express/Delphi 5


You can with ADOX (Microsoft ADO Extensions for DDL and Security), e.g.:

var
  V: Variant;
begin
  V := CreateOleObject('ADOX.Catalog');
  V.Create('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\new.mdb');
end;

"Scott Skiba" <ssk...@controlmaster.com> schreef in bericht
news:hzXh5.3821$Z6.162746@newsread1.prod.itd.earthlink.net...

Quote

> Can I create a new MS Access database using the JET.40.OLE DB PROVIDER.?
The
> ADO Connection object or Command object
> allow access to an existing database but I cannot seem to create one since
> the connection object requires a database in order to
> authenticate itself upon startup/initialization.

> Cheers,
> Scott

> --
> SCOTT F SKIBA
> Control Master Inc.
> Phone: 908-735-9002
> Fax    :  908-735-8902
> Email : ssk...@controlmaster.com

Other Threads