Results 1 to 5 of 5

Thread: Getting Tables of Database

  1. Apr 30th, 2001, 08:04 AM #1
    Cyrus13
    Cyrus13 is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2001
    Location
    Greece
    Posts
    184

    Getting Tables of Database

    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!
    Reply With Quote Reply With Quote
  2. Apr 30th, 2001, 08:23 AM #2
    Jimbob
    Jimbob is offline
    Hyperactive Member
    Join Date
    Apr 2000
    Location
    Isle of Man
    Posts
    276
    in sql server, look in the master database. i wouldnt know about access, though
    Reply With Quote Reply With Quote
  3. Apr 30th, 2001, 08:42 AM #3
    Cyrus13
    Cyrus13 is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2001
    Location
    Greece
    Posts
    184
    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.
    Reply With Quote Reply With Quote
  4. Apr 30th, 2001, 09:19 AM #4
    Gaffer
    Gaffer is offline
    Fanatic Member Gaffer's Avatar
    Join Date
    Nov 2000
    Location
    London
    Posts
    828
    See mu post:

    http://forums.vb-world.net/showthrea...threadid=66816
    Reply With Quote Reply With Quote
  6. Apr 30th, 2001, 09:42 AM #5
    Cyrus13
    Cyrus13 is offline

    Thread Starter
    Addicted Member
    Join Date
    Mar 2001
    Location
    Greece
    Posts
    184
    Works just fine!! Thanks a lot my good friend!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width