Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get all the db's tablenames from code??

Status
Not open for further replies.
notageek7

notageek7

Technical User
Jan 23, 2004
54
US
Can I get all my db's tablenames from a module, if so how do I do it? I've looked through FAQ's and and searched other forums and only found something about sysobj and metadata but it wasn't a clear solution that I could understand. Can somebody help please? Thanks in advance.
 
Sort by date Sort by votes
Take a look at the DAO.TableDefs collection.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open 1
Replies
14
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
1K
Andrzejek
Andrzejek
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
868
dhookom
dhookom
feipezi
  • Locked
  • Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
1K
combo
combo
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
580
Viswa.R
Viswa.R

Part and Inventory Search

Sponsor

Back
Top