Best way to copy data across ?

[Peter]

End users are using an Access 2003 Database with both front end and back
end.

There is a requirement to add fields in a particular table and change the
forms and reports accordingly. I have made a new copy of both front end and
back end while end users are still using the database.

I would like to know what is the best way to copy all data from production
to the newly developed backend ? (How to import data to table) ?

Thanks

 

[Douglas J. Steele]

Why not just alter the existing backend? Kick everyone off the system
briefly and make the changes. Alternatively, write VBA code to make the
changes for you. Tony Toews has a sample at
http://www.granite.ab.ca/access/backendupdate.htm

 

[Peter Hibbs]

Peter.

If you want to add tables or fields to your client back-end file
automatically, have a look at :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE Update Utility.mdb'

and to relink the front-end after an update ;-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

HTH

Peter Hibbs.