query for getting list of tables in a database

[sindhutiwari]

hi My aim is to get list of tables in a database (access) if any one has any idea please let me know thank u regards sindhu tiwari

its me sid

[Hesham Amin]

Check this FAQ[^]

---

Hesham A. Amin My blog

[Widgets]

you can see list of table in sysobjects table of your database.. this is where the names of table is reside...

[Paul Conrad]

Wish I could have had that link a couple months ago. I wound up doing the same general query after digging around inside Access :->

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon