Tables in an .mdb file

Jesús Avilés Martínez

Delphi Developer

Mon, 03 Jan 2005 17:37:35 GMT

Tables in an .mdb file

Hi all,

I'd like to know how can i get the names of all tables inside an Access database. I think that i cannot get it through a TADOConnection object.

Many thanks

---------------------
JAM - Reljate y disfruta

MSF

Delphi Developer

Mon, 03 Jan 2005 19:16:20 GMT

Re:Tables in an .mdb file

Hi.

ADOConnection1.GetTableNames(ListBox1.Items, False);

This will return your list of tables.

M.S

U?ytkownik Jess Avils Martnez <jamj...@PEICHjazzfree.com> w wiadomo?ci do
grup dyskusyjnych napisa3:3d368c5f$1_1@dnews...

Quote

> Hi all,

> I'd like to know how can i get the names of all tables inside an Access

database. I think that i cannot get it through a TADOConnection object.

Quote

> Many thanks

> ---------------------
> JAM - Reljate y disfruta

Jesús Avilés Martíne

Delphi Developer

Mon, 03 Jan 2005 18:27:46 GMT

Re:Tables in an .mdb file

Quote

"MSF" <ma...@o2.pl> wrote:
>Hi.

>ADOConnection1.GetTableNames(ListBox1.Items, False);

>This will return your list of tables.

>M.S

Many thanks for your help

---------------------
JAM - Reljate y disfruta

Mike Collie

Delphi Developer

Mon, 03 Jan 2005 18:31:09 GMT

Re:Tables in an .mdb file

To get it through TAdoConnection object use the OpenSchema method.

--
Mike Collier BSc (Hons) - www.adoanywhere.com
ADO Object Browser and COM Server.
Consultancy and Design - ADO & Database Specialists.

"Jess Avils Martnez" <jamj...@PEICHjazzfree.com> wrote in message
news:3d368c5f$1_1@dnews...

Quote

> Hi all,

> I'd like to know how can i get the names of all tables inside an Access

database. I think that i cannot get it through a TADOConnection object.

Quote

> Many thanks

> ---------------------
> JAM - Reljate y disfruta

Brian Bushay Team

Delphi Developer

Tue, 04 Jan 2005 11:35:48 GMT

Re:Tables in an .mdb file

Quote

>I'd like to know how can i get the names of all tables inside an Access database. I think that i cannot get it through a TADOConnection object.

TadoConnection.GetTableNames
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. Query using tables in different .mdb files

2. How to I create a Access database (not table, but a .mdb file) directly from code?

3. Copy a table from a .MDB to other .MDB

4. Export and import tables from MDB-Files to Ecxelsheets

5. Rename the table in mdb file using SQL statement

6. Paradox tables Vs MDB files

7. Workgroup File Error in MDB File

8. Access 2000 .mdb tables

9. Copy data into another table? MDB->DB4

10. Add a new Table to a MDB Database