Imiporting Table Definitions

[Jim Shaw]

BlankMy application is split into a front end logic and back end data
database. This allowed my client to start using the application while I
continued development. Now I have new features whose implementation
required the addition of additional columns in several existing tables. My
forms work against the new table definitions in my test data base. Now I
need to deploy the updated application, but I'm faced with making a lot of
changes to the production data base introducing the probability of mistakes.

I'm looking for an automated way (read less risky) to import the modified
table specifications into an existing database. I don't want the test data,
just the specs.

Any ideas on how to do this?

Thanks
Jim

 

[Douglas J. Steele]

Take a look at what Tony Toews has at
http://www.granite.ab.ca/access/backendupdate.htm