Hi Everyone,
In DAO there is an tabledef object where you have the ability to find out all the names of all tables inside an MDB file. Can anybody show me a code on how to do that in ADO. Thanks in advance.
Newvbguy
NewVBguy
3
Junior Poster in Training
Recommended Answers
Jump to Postif you don't know how to use VB with Access/Sql, I suggest you read the sticky thread: http://www.daniweb.com/techtalkforums/thread41057.html to get a stronger understanding of ADO. Once you are comfortable with that information, you would need to use the OpenSchema method to get the adSchemaTables.... I guess it would be …
All 2 Replies
Comatose
290
Taboo Programmer
Team Colleague
if you don't know how to use VB with Access/Sql, I suggest you read the sticky thread: http://www.daniweb.com/techtalkforums/thread41057.html to get a stronger understanding of ADO. Once you are comfortable with that information, you would need to use the OpenSchema method to get the adSchemaTables.... I guess it would be something like:
rsTables = cnn.OpenSchema(adSchemaTables)
do while not rsTables.EOF
loopor something nuts.
NewVBguy
3
Junior Poster in Training
Hi Comatose,
Thanks a lot.. you're really giving us a big help.
have a good day.
Newvbguy
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.