patch database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NiXa - 16 Jan 2005 17:22 GMT

hi, i have a database that i have to upgrade. i'm planning to create another
database that should "patch" the original database. does someone know how
can i delete objects (forms, modules, etc..) in original database from
within "patch" database.

thank you,
nixa

Reply to this Message

Douglas J. Steele - 16 Jan 2005 17:30 GMT

What you should do is split the application into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships). Each user should have a copy of
the front-end on his/her hard drive.

To distribute a new version, you simply replace the existing front-end with
the new one.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> hi, i have a database that i have to upgrade. i'm planning to create
> another
[quoted text clipped - 4 lines]
> thank you,
> nixa

Reply to this Message

Albert D. Kallal - 17 Jan 2005 05:04 GMT

Just split your database, and then send them the new front end, and have
that link to their existing application.

(you will need to caution them to run your new front end..and not the old
actual database).

This would be stop gap fix, until you can get on-site, and actually split
their database, and then re-link the front end to the back end...

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Reply to this Message