Re: Reading tables structure
From: Joshua A. Booker (joshuaabookerhot_at_mail.com)
Date: 03/19/04
- Next message: Alan Z. Scharf: "Re: Description for Linked table"
- Previous message: Alan Z. Scharf: "Re: Description for Linked table"
- In reply to: Mark: "Re: Reading tables structure"
- Next in thread: Mark: "Re: Reading tables structure"
- Reply: Mark: "Re: Reading tables structure"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Mar 2004 09:43:13 -0500
Mark,
Could you simply copy the table's structure to a new table with a Make-Table
Query?
Or do you have other reasons for needing the structure attributes stored in
an attributes table?
HTH,
Josh
"Mark" <anonymous@discussions.microsoft.com> wrote in message
news:d4a701c40dbb$7a2d4890$a601280a@phx.gbl...
> Josh,
>
> I appreciate your reply, but while I could go that route,
> it seems like a lot of extra work. I'm looking to build a
> module that will create tables in a temporary database
> that I can delete when done. Since the table structures
> may change, I would rather update the structure table than
> modify the code. Or better yet, set up example tables,
> read there structure, and create the same structure in the
> temporary database.
>
> Mark
> >-----Original Message-----
> >Mark,
> >
> >Access has a built-in documenter tool that prints a
> detailed report of db
> >objects and properies.
> >
> >Try: Tools | Analyze | Documenter
> >
> >HTH,
> >Josh
> >
> >"Mark" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:101b901c40db7$f175c520$a401280a@phx.gbl...
> >> Does anyone have a subroutine they mind sharing that
> would
> >> create a table of the table, field names and properties
> in
> >> a database. I've searched the help, but I don't seem to
> >> be having any luck.
> >>
> >> Thanks,
> >>
> >> Mark
> >
> >
> >.
> >
- Next message: Alan Z. Scharf: "Re: Description for Linked table"
- Previous message: Alan Z. Scharf: "Re: Description for Linked table"
- In reply to: Mark: "Re: Reading tables structure"
- Next in thread: Mark: "Re: Reading tables structure"
- Reply: Mark: "Re: Reading tables structure"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|