Importing ADOX library - How?

Howdy all,

I have an Access Database I need to modify programatically at runtime. Basically I would like to be able to distribute newer revisions of a client that works with the database and allow the newer clients to add fields. In case the client has introduced support for a new field, I would like to see that added.

I did aks this before and had alternative solutions to it, but I am persistent in wanting to do it my way :-)

So, I do understand that ADOX is the way to get programatical access to the database structure rather than the actual data. There is no wrapper for the functionality shipped with Delphi, but one can of course just follow the brilliant guides on-line, like these ones:

http://delphi.about.com/od/database/l/aa072401a.htm
http://www.swissdelphicenter.ch/torry/showcode.php?id=1427
http://beaussier.developpez.com/articles/delphi/adox/

Only they assume older version of Delphi. In 2006 and 2007 I can select Component -> Import Component followed by TypeLibrary but then there is no way to rename anything. Not that I speak any russian, but this thread is probably talking on the subject and the last post references an additional component (ADOX Component Suite by Winsoft.sk):

http://forums.realcoding.net/index.php?showtopic=14796

A similar thread is this one, but then again I don't speak Dutch either:

http://www.nldelphi.com/forum/showthread.php?t=23299

(The post by CameO73 looks interesting - I wish I could understand it!)

So let's assume I don't want to purchase any additional components but only to import ADOX to my Delphi 2007. How do I do it????

/Pontus Berg
.

Relevant Pages

  • Re: Help! How do I create a database?
    ... Relatively new to Delphi, but not to programming in general, I would ... ADOX package from inside my form. ... As stated in the mentioned chapter, ADO Extensions for Data Definition Language and Security is an extension to the ADO objects and programming model. ... ADOX gives developers a rich set of tools for gaining access to the structure, security model, and procedures stored in a database. ...
    (alt.comp.lang.borland-delphi)
  • Re: Linking tables via ADO?
    ... Properties for user-level security on an ADOX Table object, ... syntax that works just fine for an ADO Connection object, ... to connect to an Access database with ADO after it has been secured with ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Linking tables via ADO?
    ... Properties for user-level security on an ADOX Table object, ... syntax that works just fine for an ADO Connection object, ... to connect to an Access database with ADO after it has been secured with ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Re: ADOX - Import type library into Delphi 2007
    ... I want to modify an Access database at runtime and this takes ADOX (not only ADO but also ADOX so you can f.ex. ... I might add that I have been given the suggestion to rename the MDB file, create a new table, create a new table and them migrate the data from the old file to the new. ...
    (borland.public.delphi.database.ado)
  • Re: Ridiculously Easy Question for Delphi-Access Experts (Cry for help)
    ... >I have an Access database and would like to write a customised user ... I placed a Table, Database and Datasource components on a form, ... >Delphi books I have. ... Paul Sherwin Consulting ...
    (alt.comp.lang.borland-delphi)