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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

save table structure to a table

Status
Not open for further replies.
abenitez77

abenitez77

IS-IT--Management
Oct 18, 2007
147
US
How can I get the table structure of access 2007 local tables and linked (ms sql 2005/2008) tables and save it to a table?
 
Sort by date Sort by votes
faq700-6905
will show you how to get your table structure. Currently just writes to the debug window but you can easily use an insert query to a table.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
623
Andrzejek
Andrzejek
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
334
Zyborg
Zyborg
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
362
Moss100
Moss100
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
362
Moss100
Moss100
btamsgn
  • Locked
  • Question
How to add lines from textbox to table 1
Replies
8
Views
230
MattGreer
MattGreer

Part and Inventory Search

Sponsor

Back
Top