change to database fields within tables

[Dave]

Hello,
I sell software to companies and install on their internal servers a website
that uses Access 2000 as the database. I am struggling with how to handle
updates to the tables when I need them. Is there a way to access the tables
and make changes to them from a secure internet site? Any suggestions on how
to best handle updates? I am new to selling software.

Thanks,
Dave

 

[Duane Hookom]

Usually this suggests a new front end. I generally would include code to
determine if a structure is up-to-date. If I need to make changes, I use DAO
to add fields or whatever.

Other solutions I have seen install a new back-end mdb with all the tables.
Code is then used to import the existing records into the new
structure/tables. The new back-end then becomes the active back-end.