ADOX copy database

Greetings,

I have a procedure that takes an existing Access database and makes a copy
of it (structure only) using ADOX. However, I have the following problems
with the copy:

AutoNumber fields in the original MDB file become plain old Numeric fields
in the copy.
The columns lose their default value property that was present in the
original MDB file.
Text fields are all Required, where they were not in the original MDB file.

In my procedure, I create Table, Column, Index and Key objects. When I try
to use the Properties collection of the ADOX.Column objects such as
"default", etc., I get errors indicating that the item is not found in the
collection.

Does anyone know of problems in carrying over default values and
auto-increment fields from a source to a copy database using ADOX? Is there
some special way I need to handle appending the columns to tables? Is there
a special index or key I need to append or modify?

Please help.

Thanks.

- will f


.

Relevant Pages

  • ADOX database copy
    ... I have a procedure that takes an existing Access database and makes a copy ... AutoNumber fields in the original MDB file become plain old Numeric fields ... auto-increment fields from a source to a copy database using ADOX? ... some special way I need to handle appending the columns to tables? ...
    (microsoft.public.vb.database)
  • ADOX copy database
    ... I have a procedure that takes an existing Access database and makes a copy ... AutoNumber fields in the original MDB file become plain old Numeric fields ... auto-increment fields from a source to a copy database using ADOX? ... some special way I need to handle appending the columns to tables? ...
    (microsoft.public.vb.database.ado)
  • Re: Advice on creating a DataTable to place into Blank MS Access DB file
    ... >structure as the Dataset built from the CSV file. ... And I am building the Access database and Table with ADOX. ... >So, there are other ways besides, using SQL statements to build a new table and database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Append field to existing table
    ... ADOX to add new fields to the existing table. ... which will add this field using ALTER TABLE SQL statement ... I do not know exact syntax of the ALTER TABLE statement for Access database, ...
    (microsoft.public.vb.database.ado)