-
Nov 3rd, 2020, 11:07 AM
#1
Thread Starter
PowerPoster
iterate table in access database
I need and get the name of each table in database, how to?
-
Nov 3rd, 2020, 11:13 AM
#2
Re: iterate table in access database
Step by step process:
1. Open a web browser
2. Enter https://www.google.com into the address bar
3. When the page loads, enter "microsoft access get table names from database" into the Search box and press Enter.
4. When the results appear, right-click on some of the links and select "Open in new Tab"
5. Read the information on the links found
-
Nov 4th, 2020, 01:38 AM
#3
Re: iterate table in access database
Originally Posted by jdc2000
Step by step process:
1. Open a web browser
2. Enter https://www.google.com into the address bar
3. When the page loads, enter "microsoft access get table names from database" into the Search box and press Enter.
4. When the results appear, right-click on some of the links and select "Open in new Tab"
5. Read the information on the links found
excellent explanation for Luca, hope he will Post less ...how to?... now
to hunt a species to extinction is not logical !
since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.
-
Nov 4th, 2020, 02:01 AM
#4
Addicted Member
Re: iterate table in access database
Add a reference to Microsoft ADO Ext. for DDL and Security to your project and try:
Code:
Dim cat As ADOX.Catalog
Dim T As ADOX.Table
Set cat = New ADOX.Catalog
With cat
'put your string connection here
.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\Program Files (x86)\Microsoft Visual Studio\VB98\BIBLIO.MDB"
For Each T In .Tables
Debug.Print T.Name
Next T
End With
-
Nov 4th, 2020, 09:48 AM
#5
Re: iterate table in access database
You can also use Connection.OpenSchema() to query the tables list.
-
Nov 4th, 2020, 10:34 AM
#6
Hyperactive Member
Re: iterate table in access database
Originally Posted by jdc2000
Step by step process:
1. Open a web browser
2. Enter https://www.google.com into the address bar
3. When the page loads, enter "microsoft access get table names from database" into the Search box and press Enter.
4. When the results appear, right-click on some of the links and select "Open in new Tab"
5. Read the information on the links found
This should be marked as the answer, but in general I would recommend preceding the search with "vb6" or even "vbforums", so enter "vb6 microsoft access get table names from database" and you will get results for VB higher in your search, many from this very site.
I presume that Google is smart enough to look for English from the search criteria that you enter nowadays, but you might also try selecting English in Advanced Search?
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
|