good morning all,

we are developing a complex electronic system related to the energy saving;
a central and remote server control and manage all the systems installed in
the territory. This server has a big database to collect all the structural
and operational systems information; we are designing the database using
Microsoft Access. Since we have to describe the entire system, and so even
the database structure and relations, we need to copy the database tables
structure in a word report document (including the fields names, the kind of
data and the description of every table field). It seems a silly things, but
we are not able to export the structure of the table in a word table (the
copy-and-past function doesn't work in this case) and we cannot copy manually
every field of every table 'cause this is a real time wasting. Does anybody
have an idea how to do? Thank you very much, from Italy

Federico

Tools/Analyze/Documenter (access 2003)
The Actual Data to be found in
C:\Documents and Settings\%username%\Application
Data\Microsoft\Access\ACWZUSRT.MDT

HTH

Pieter

"Federico Bari" <(E-Mail Removed)> wrote in message
news:37D0EBA6-4BD2-4297-8E71-(E-Mail Removed)...
> good morning all,
>
> we are developing a complex electronic system related to the energy
> saving;
> a central and remote server control and manage all the systems installed
> in
> the territory. This server has a big database to collect all the
> structural
> and operational systems information; we are designing the database using
> Microsoft Access. Since we have to describe the entire system, and so even
> the database structure and relations, we need to copy the database tables
> structure in a word report document (including the fields names, the kind
> of
> data and the description of every table field). It seems a silly things,
> but
> we are not able to export the structure of the table in a word table (the
> copy-and-past function doesn't work in this case) and we cannot copy
> manually
> every field of every table 'cause this is a real time wasting. Does
> anybody
> have an idea how to do? Thank you very much, from Italy
>
> Federico

Additional hint:
With the documenter Report open.
Press Ctrl + G
type:
?Reports(0).recordsource

HTH

Pieter

"Federico Bari" <(E-Mail Removed)> wrote in message
news:37D0EBA6-4BD2-4297-8E71-(E-Mail Removed)...
> good morning all,
>
> we are developing a complex electronic system related to the energy
> saving;
> a central and remote server control and manage all the systems installed
> in
> the territory. This server has a big database to collect all the
> structural
> and operational systems information; we are designing the database using
> Microsoft Access. Since we have to describe the entire system, and so even
> the database structure and relations, we need to copy the database tables
> structure in a word report document (including the fields names, the kind
> of
> data and the description of every table field). It seems a silly things,
> but
> we are not able to export the structure of the table in a word table (the
> copy-and-past function doesn't work in this case) and we cannot copy
> manually
> every field of every table 'cause this is a real time wasting. Does
> anybody
> have an idea how to do? Thank you very much, from Italy
>
> Federico

thank you very much. The only thing that seems to be missed is the culomn
"description".

Federico

"Pieter Wijnen" wrote:

> Tools/Analyze/Documenter (access 2003)
> The Actual Data to be found in
> C:\Documents and Settings\%username%\Application
> Data\Microsoft\Access\ACWZUSRT.MDT
>
> HTH
>
> Pieter
>
> "Federico Bari" <(E-Mail Removed)> wrote in message
> news:37D0EBA6-4BD2-4297-8E71-(E-Mail Removed)...
> > good morning all,
> >
> > we are developing a complex electronic system related to the energy
> > saving;
> > a central and remote server control and manage all the systems installed
> > in
> > the territory. This server has a big database to collect all the
> > structural
> > and operational systems information; we are designing the database using
> > Microsoft Access. Since we have to describe the entire system, and so even
> > the database structure and relations, we need to copy the database tables
> > structure in a word report document (including the fields names, the kind
> > of
> > data and the description of every table field). It seems a silly things,
> > but
> > we are not able to export the structure of the table in a word table (the
> > copy-and-past function doesn't work in this case) and we cannot copy
> > manually
> > every field of every table 'cause this is a real time wasting. Does
> > anybody
> > have an idea how to do? Thank you very much, from Italy
> >
> > Federico
>
>
>

Hi Federico,

Which version of Access are you using?

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"Federico Bari" wrote in message:
news:37D0EBA6-4BD2-4297-8E71-(E-Mail Removed)...

> good morning all,
>
> we are developing a complex electronic system related to the energy
> saving;
> a central and remote server control and manage all the systems installed
> in
> the territory. This server has a big database to collect all the
> structural
> and operational systems information; we are designing the database using
> Microsoft Access. Since we have to describe the entire system, and so even
> the database structure and relations, we need to copy the database tables
> structure in a word report document (including the fields names, the kind
> of
> data and the description of every table field). It seems a silly things,
> but
> we are not able to export the structure of the table in a word table (the
> copy-and-past function doesn't work in this case) and we cannot copy
> manually
> every field of every table 'cause this is a real time wasting. Does
> anybody
> have an idea how to do? Thank you very much, from Italy

2007

"Jeff Conrad [MSFT]" wrote:

> Hi Federico,
>
> Which version of Access are you using?
>
> --
> Jeff Conrad - Access Junkie - MVP Alumni
> SDET - XAS Services - Microsoft Corporation
>
> Co-author - Microsoft Office Access 2007 Inside Out
> Presenter - Microsoft Access 2007 Essentials
> http://www.accessmvp.com/JConrad/accessjunkie.html
> Access 2007 Info: http://www.AccessJunkie.com
>
> ----------
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.mspx
> ----------
>
> "Federico Bari" wrote in message:
> news:37D0EBA6-4BD2-4297-8E71-(E-Mail Removed)...
>
> > good morning all,
> >
> > we are developing a complex electronic system related to the energy
> > saving;
> > a central and remote server control and manage all the systems installed
> > in
> > the territory. This server has a big database to collect all the
> > structural
> > and operational systems information; we are designing the database using
> > Microsoft Access. Since we have to describe the entire system, and so even
> > the database structure and relations, we need to copy the database tables
> > structure in a word report document (including the fields names, the kind
> > of
> > data and the description of every table field). It seems a silly things,
> > but
> > we are not able to export the structure of the table in a word table (the
> > copy-and-past function doesn't work in this case) and we cannot copy
> > manually
> > every field of every table 'cause this is a real time wasting. Does
> > anybody
> > have an idea how to do? Thank you very much, from Italy
>
>
>

2007

"Jeff Conrad [MSFT]" wrote:

> Hi Federico,
>
> Which version of Access are you using?
>
> --
> Jeff Conrad - Access Junkie - MVP Alumni
> SDET - XAS Services - Microsoft Corporation
>
> Co-author - Microsoft Office Access 2007 Inside Out
> Presenter - Microsoft Access 2007 Essentials
> http://www.accessmvp.com/JConrad/accessjunkie.html
> Access 2007 Info: http://www.AccessJunkie.com
>
> ----------
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.mspx
> ----------
>
> "Federico Bari" wrote in message:
> news:37D0EBA6-4BD2-4297-8E71-(E-Mail Removed)...
>
> > good morning all,
> >
> > we are developing a complex electronic system related to the energy
> > saving;
> > a central and remote server control and manage all the systems installed
> > in
> > the territory. This server has a big database to collect all the
> > structural
> > and operational systems information; we are designing the database using
> > Microsoft Access. Since we have to describe the entire system, and so even
> > the database structure and relations, we need to copy the database tables
> > structure in a word report document (including the fields names, the kind
> > of
> > data and the description of every table field). It seems a silly things,
> > but
> > we are not able to export the structure of the table in a word table (the
> > copy-and-past function doesn't work in this case) and we cannot copy
> > manually
> > every field of every table 'cause this is a real time wasting. Does
> > anybody
> > have an idea how to do? Thank you very much, from Italy
>
>
>

I have an Access add-in that does this quite nicely:
http://www.accessmvp.com/JConrad/acc.../csdtools.html

Unfortunately, I haven't had time yet to make it compatible with Access
2007.
:-(

You might want to take a look at this page for some options:
http://www.accessmvp.com/JConrad/acc.../doctable.html

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"Federico Bari" wrote in message:
news:9CBFB63D-25B7-42DD-A077-(E-Mail Removed)...

> 2007
>
> "Jeff Conrad [MSFT]" wrote:
>
>> Hi Federico,
>>
>> Which version of Access are you using?

thank you i will give a look! maybe i can save the db in an older access
format! ;-)

federico

"Jeff Conrad [MSFT]" wrote:

> I have an Access add-in that does this quite nicely:
> http://www.accessmvp.com/JConrad/acc.../csdtools.html
>
> Unfortunately, I haven't had time yet to make it compatible with Access
> 2007.
> :-(
>
> You might want to take a look at this page for some options:
> http://www.accessmvp.com/JConrad/acc.../doctable.html
>
> --
> Jeff Conrad - Access Junkie - MVP Alumni
> SDET - XAS Services - Microsoft Corporation
>
> Co-author - Microsoft Office Access 2007 Inside Out
> Presenter - Microsoft Access 2007 Essentials
> http://www.accessmvp.com/JConrad/accessjunkie.html
> Access 2007 Info: http://www.AccessJunkie.com
>
> ----------
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.mspx
> ----------
>
> "Federico Bari" wrote in message:
> news:9CBFB63D-25B7-42DD-A077-(E-Mail Removed)...
>
> > 2007
> >
> > "Jeff Conrad [MSFT]" wrote:
> >
> >> Hi Federico,
> >>
> >> Which version of Access are you using?
>
>
>