Edit a table structure using vb code or an access macro

[Gary_Mc_Mahon]

Hi,

I trying to alter the field names, formats and aa fields within a table once its been imported into my database.

Is there any way to do it using the macro builder, or can it be done using vbcode in the same way a qry def can be created by setting the sql and assigning a qry name.

Thanks
Gary

 

[Norie]

Gary

Take a look at TableDefs.

It is a collection of all the TableDef objects in the database.

Each of the TableDef objects has a Fields collection.

This will give you access to each field in the table but I'm not sure what, if any, properties you can change.

For example I know you can't change the size of the field.

Another approach could be to create a new TableDef based on the original fields but with the properties changed as required.

You could then use an append query, or other method, to put the data in the new table.