Re: MS Access table and field properties



Look at TADOConnection.OpenSchema(siColumns).

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"TMA" <tmasoftwares@xxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:4310ac19@xxxxxxxxxxxxxxxxxxxxxxxxx
> I'm using D7 and would like to retrieve some field properties using ADO
> from a MS Access database. I need to know for each given table name the
> list with field names, and in each field, it's type (number, string, etc),
> it's maximum size and the comments i write on MS Access main program.
> Help with some source code would be appreciated.
> Thanks in advance.
>


.



Relevant Pages

  • Re: index list with ado?
    ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
    (borland.public.delphi.database.ado)
  • Re: Looking for free installer program
    ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Bitmaps in SynEdit
    ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: a connection problem
    ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
    (borland.public.delphi.database.ado)
  • Re: How to record quotation marks
    ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase (through OLEDB) ...
    (borland.public.delphi.database.ado)

Quantcast