transfering table design

[Andre C]

Sorry to ask such a simple question but a quick google search drew
blanks.

I am adapting a table design (adding new fields etc) in the prototype
database whilst the real world one is used by others. How do I
transfer table changes to the real world model. Presently I have to
manually add in the new fields etc.

 

[Craig Alexander Morrison]

Check out DDL, that is SQL Statements that are capable of Data Definition as
opposed to DML (Data Manipulation).

Search Help for DDL.

 

[Andre C]

Search Help for DDL.

I did and it said the term was not recognised. (Access 2000) But I am
not after a SQL solution. I simply want to transfer the change I have
made inteh table structure to the real world model.

 

[Craig Alexander Morrison]

What have you got against SQL?

Anyway you can also use the DAO Create methods instead.

You will need to create a small Front End application to carry out these
instructions whether using SQL or DAO Create and then run it once against
the Back End database.

You may need to use online help from MS as I believe Access 2000 had a piss
poor help system.

Both DDL and DAO Create methods are clearly explained in Access 97 and
Access 2003 offline help systems.