How can i update automaticaly the tables field descriptions?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have many big tables that where imported to Access. Now I want to add the
field description for them.
Is there any easy way to do that?
Thanks.
Ahron
 
Open the Table in Design View and you can add Field Description to each
Field.
 
Thank you,

Maybe i was not clear enough.
I want to add it automaticaly. I have the description in another table (as
records) and i want to add them to the original table. Copy Paste is too much
time consuming (around 2000 fields in several tables)

Thanks.
 
It can be done, providing there is a way to determine which description
should be used for a specific field. Please provide more information about
table design and contents.
 
Field Description is an Access Property, not JET Property so you need to use
the CreateProperty method to create the Property "Description".

Check Access VB Help (DAO section) on the CreateProperty method. There are
some sample code in this Help topic also.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

join tables using a key field 3
Copy a linked table, including descriptions 2
Using a formula to fill a field 1
Printing Access Table Field Descriptions 2
table design 3
TYPE CONVERSION FAILURE - text to text field 3
Data in data sheet to fields in another table 1
Updating tables when you input new data 0

Back
Top