change to database fields within tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 03 Jan 2005 23:15 GMT

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

Reply to this Message

Duane Hookom - 04 Jan 2005 01:40 GMT

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.

Signature

Duane Hookom
MS Access MVP

> Hello,
> I sell software to companies and install on their internal servers a
[quoted text clipped - 8 lines]
> Thanks,
> Dave

Reply to this Message