Adding to a Table

[Tallbloke]

I'm currently doing a large update to a split frontend / backend database.

I've made a local copy to work on.

I know changes to front end are easy, I can just over write the file on the client machines.

However, what is the best method to update the existing tables. They have new data since I started working on them.

Is there a way to copy across just the new fields form my local copy?

Or is it simply a case of a copy and paste job?

 

[pbaldy]

Options include adding the fields in design view of the production backend and creating/executing DDL SQL against it (ALTER TABLE...). Either way, I'd get everybody out first. I'm usually offsite when I have customers with an Access backend, so I send them an Access file with the DDL SQL in it. They click a button and it's done. It's a little easier with SQL Server, as it will create the SQL for you.