changing table fields once data is entered into db

[clientuser]

i have a vb application that will be distributed with an access backend.

if i make updates to the access database say later on and add fields or change field names etc and the user has already entered data into their db, how can this best be handled?

 

[dhookom]

You can use DAO code to add fields (or even tables) in mdb files.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[PHV]

You may also consider the ALTER TABLE sql instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244