|
-
Aug 13th, 2002, 04:45 AM
#1
Thread Starter
New Member
How do i retrieve the table names on my Access database?
im using an mdb database (Microsoft Access)
i made my oledbconnection thru code:
Dim cnn As OleDbConnection
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
"Data Source=C:\mydata.mdb;" + _
"Mode=Share Deny None"
cnn = New OleDbConnection(strConn)
dragging the tables from the server explorer into my form is not appropriate for my application, because additional tables might be added to the database in the future.
what i want is to display all the table names inside "mydata.mdb" on myListBox control.
do i need additional objects such as oledbcommand,...
pls fill up the missing code. thanks a lot!
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
|