B
Beth
I have a FE/BE database setup. The front end could link to many different
backend databases with similar strutctures. The applications have been
deployed to customers and I continue to modify the front end. On occassion
I need to add fields to the backend files that they maintain.
At the main switchboard form, on open, I would like to verify that a field
(as an example: txtName) exists in the linked backend table. If it doesn't
exist, I would like the code to automatically add the field to the backend
database that the user maintains.
Thanks in advance. This has been a sticky issue for me and I can't have
customers send me their datafiles just to add a field.
Beth
backend databases with similar strutctures. The applications have been
deployed to customers and I continue to modify the front end. On occassion
I need to add fields to the backend files that they maintain.
At the main switchboard form, on open, I would like to verify that a field
(as an example: txtName) exists in the linked backend table. If it doesn't
exist, I would like the code to automatically add the field to the backend
database that the user maintains.
Thanks in advance. This has been a sticky issue for me and I can't have
customers send me their datafiles just to add a field.
Beth