Access 2000

  • Thread starter Thread starter Lou Civitella
  • Start date Start date
L

Lou Civitella

Using ADO how can I copy a column from one table into another?

What I have created is an Access 2000 utility that updates my backend
database from another 'master' database. The utility opens the 'master'
database and compares the tables, columns and columns properties to the same
in my backend database. If anything is different (new table, new columns,
changed property) the utility fixes the backend to make it have the same
structure as the 'master' database. I was just wondering if there was a way
to copy a column from one table to another without having to add the column
and the go through all the properties and update them based on the 'master'.

Thanks In Advnace,
Lou
 
If the tables are Jet tables (native access) or Sql Server You could write
some DDL scripts to Add, Drop, or Alter tables that need to change. For
instance:

docmd.RunSQL "Alter Table TableNameAdd Column NewColumnName Char(50)"

would add a new column "NewColumnName" to an existing table "TableName".

There is a little more information in Access help. Search on "alter table"
in the answer wizzard.

Ron W
 
Lou Civitella said:
Using ADO how can I copy a column from one table into another?

What I have created is an Access 2000 utility that updates my backend
database from another 'master' database. The utility opens the 'master'
database and compares the tables, columns and columns properties to the same
in my backend database. If anything is different (new table, new columns,
changed property) the utility fixes the backend to make it have the same
structure as the 'master' database. I was just wondering if there was a way
to copy a column from one table to another without having to add the column
and the go through all the properties and update them based on the 'master'.

Thanks In Advnace,
Lou
Click to expand...
 
Lou Civitella said:
Using ADO how can I copy a column from one table into another?

What I have created is an Access 2000 utility that updates my backend
database from another 'master' database. The utility opens the 'master'
database and compares the tables, columns and columns properties to the same
in my backend database. If anything is different (new table, new columns,
changed property) the utility fixes the backend to make it have the same
structure as the 'master' database. I was just wondering if there was a way
to copy a column from one table to another without having to add the column
and the go through all the properties and update them based on the 'master'.

Thanks In Advnace,
Lou
Click to expand...
 
Back
Top