display columns in access - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

display columns in access

Author

Topic

rajeshkumar77
Starting Member

46 Posts

Posted - 2002-05-09 : 10:16:55

Dear friends,
I oracle we have statement to display the columns of a specific table like .. desc emp;
Is there anything like that in ms access ?
if anyone having idea on this, please share ur ideas.
Thanks in advnace.
Yours
Rajesh

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2002-05-09 : 22:06:27

Greetings fello Aussie

Yes there is. Are you using DAO 3.6 (ie is it an .mdb?)

If so:
Dim db as Database
Dim tdf as Tabledef
set db = CurrentDb
Set tdf = db.Tabledefs("TableName")
MsgBox tdf.Fields.Count

Set tdf = nothing
Set db = nothing

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources