Hello!! I have an access database and an SQLServer database and I'm connecting to it through ADO! I would like to know if there is a way of getting every table name in the database!
Thanks in advance!
Printable View
Hello!! I have an access database and an SQLServer database and I'm connecting to it through ADO! I would like to know if there is a way of getting every table name in the database!
Thanks in advance!
in sql server, look in the master database. i wouldnt know about access, though
Hmmmm... I want to be able from Visual Basic code to get the names of the tables!I know how to just view them from both Access and SQLServer.
Works just fine!! Thanks a lot my good friend!