Delete development data and insert production data

[rodneyb]

I have been doing some development work on an Access97 database which involves adding fields, changing field types, adding new tables etc to the database copy on my C: drive. But because of my development testing I have changed the data which is not the same as the production version data that the client currently has.

I want to be able to remove all the data from my development database and insert all the production data that the client has - is there a clean and efficient way of doing this?

Any comments are greatly appreciated.

 

[reel knotty]

I run into this quite often. I simply import the tables with the live info into my copy and adjust the fields as need then move the whole access file onto the server. (Note: Lock everyone out of the live copy before importing data and untill you get the new version back up)