M Michael Hoffmann Sep 7, 2003 #1 Hi, how can I read the count of tables and get there names from a database? cu Michael
G Greg Ewing [MVP] Sep 7, 2003 #2 Michael, it depends on how you want to do it. Here are a couple of links to get you started. http://groups.google.com/groups?hl=...1c127ad$7e6358b0$b1e62ecf@tkmsftngxa04&rnum=1 http://groups.google.com/groups?hl=...5f51&seekm=#IPDyUMOCHA.2176@tkmsftngp09#link1
Michael, it depends on how you want to do it. Here are a couple of links to get you started. http://groups.google.com/groups?hl=...1c127ad$7e6358b0$b1e62ecf@tkmsftngxa04&rnum=1 http://groups.google.com/groups?hl=...5f51&seekm=#IPDyUMOCHA.2176@tkmsftngp09#link1
W William Ryan Sep 8, 2003 #3 On SQL SErver you can query the name field of the SysTables table and get all of them for the DB. Not sure about Access, but there was a thread about a week ago with it...let me see if I can find it. Cheers, Bill
On SQL SErver you can query the name field of the SysTables table and get all of them for the DB. Not sure about Access, but there was a thread about a week ago with it...let me see if I can find it. Cheers, Bill
