Is field there? If not add it.
Posted on 2002-05-25
My app has been distributed with an Access database via DAO.
Now I have added a new field "UsersVersion" to the table "tblUserSettings."
All is fine for new users, but when I send an update out to current users they keep their old database. But the updated app looks for the new field info, its not there in the older databases, They get "Item not in collection" error.
So I need to have my app check to see if the new field is in the current database, and if not, add it.
Examples using my table and field name would be most helpful, I am green on database stuff.