Re: ADOX - Import type library into Delphi 2007

Pontus Berg skrev:
Howdy!

I asked the same question more than two years ago, and give it a new shot here as I still have got no answers I have been able to use.

I want to modify an Access database at runtime and this takes ADOX (not only ADO but also ADOX so you can f.ex. access the structure of the data and not only the data itself).

Importing a type library is very well described at many informative sites. Take this brilliant example:

http://delphi.about.com/od/database/l/aa072401a.htm

Now; How do I do that in Delphi 2007? It's totally different and renaming is not one of the options.

I might add that I have been given the suggestion to rename the MDB file, create a new table (according to the definition in the EXE), create a new table and them migrate the data from the old file to the new. This seemed like a massively bigger job than adjusting the existing database.

However, I still need to be able to do the same thing - adding columns to a database so without successful import of the ADOX type library and usage of the same, then I still need to cover a bit of ground before I am there...

/Pontus
.

Relevant Pages

  • 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)
  • Importing ADOX library - How?
    ... 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. ... I do understand that ADOX is the way to get programatical access to the database structure rather than the actual data. ... Only they assume older version of Delphi. ...
    (borland.public.delphi.database.ado)
  • Re: Backing up data
    ... Are you talking about a dBase table? ... you talking about a Table in an Access database (.mdb file)? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Working with text database in an asp page?
    ... then why not use Access database as the data source? ... I would love to use a mdb file but I am receiving this as text ...
    (microsoft.public.frontpage.programming)