Re: Creating a MS Access database

From: Denis (Denis_at_nospam.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 09:19:27 -0400

Can you tell me where I can find information about ADOX? No mention in the
help file. As for the code you sent me, it does not recognize _Catalog.
(probably because of the missing library).

Denis

> If you import the ADOX type library you can use code like this to create
an
> access database.
>
> var
> Catalog: _Catalog;
> CS,dbName: string;
> begin
> dbName := 'myNewAccessDB6.mdb';
> Catalog := CreateCOMObject(StringToGUID('ADOX.Catalog')) as _Catalog;
> CS := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + dbName
> // Engine type = 5 creates 2000 database
> +';Jet OLEDB:Engine Type=5';
> if FileExists(dbName) then
> DeleteFile(dbName);
> Catalog.Create(CS);
> Catalog := nil;

Relevant Pages

  • Re: Previous versions of Office wont uninstall when deploying Off
    ... The main Microsoft focus appears to be the "home user who is a member of the Administrators group", and who interacts with the computer by "clicking" things. ... Vista makes extensive use of Reparse Points, but if you put those words into the help file, it starts offering help about "Wireless access points"! ... var cArgs = WScript.Arguments; ... It will uninstall if I use a custom .MSP file. ...
    (microsoft.public.office.setup)
  • Re: Previous versions of Office wont uninstall when deploying Off
    ... It's been the case for a long time that Microsoft products are becoming ... The Vista help file is another good example. ... var cArgs = WScript.Arguments; ... It will uninstall if I use a custom .MSP file. ...
    (microsoft.public.office.setup)
  • Re: is Admin a kinda of a genius?
    ... I have access97, access200, accessXP and access2003 all installed on my pc. ... I have always had trouble using the help file. ... One of the most common inconvenient is not having any hint for ADOX. ... >> in these security thing), since I'm talking about a SECURED database, if ...
    (microsoft.public.access.security)
  • Re: Trying to tweak an iTunes VBScript
    ... Here is a link to the iTunes SDK: ... I extracted the iTunesCOM.chm help file from the SDK download file. ... directly access the iTunes object through a DLL. ... var mainLibrarySource = iTunesApp.LibrarySource; ...
    (microsoft.public.scripting.vbscript)
  • Re: Trying to tweak an iTunes VBScript
    ... I too am not an iTunes user or I would have used TLViewer to look at ... I extracted the iTunesCOM.chm help file from the SDK download file. ... sample JScripts that access the iTunes object through the COM ... var mainLibrarySource = iTunesApp.LibrarySource; ...
    (microsoft.public.scripting.vbscript)