Hello. This is something I've tried to do several times in the past, without success...
I have a small Access 2003 mdb app that I've developed for a small biz. As they may changes and request new features, they typically e-mail me the mdb, I edit, and e-mail back. This is a single mdb run off their server, opened by about 2-3 people simultaneously. This app is *not* run as a front-end/back-end solution, and they have expressed a desire *not* to do so... Please keep this in mind.
Instead of e-mailing back and forth (as the mdb is growing larger), I was thinking of sending them an "update" mdb that includes the updated queries, forms and reports (table structures remain the same). The update mdb would include a single small form with a button "Update". The code behind the button would connect to their mdb, wipe out the existing queries, forms and reports and export the updated ones included in the Update mdb. They could then just delete the Update mdb.
As an added bonus, if the Update app could also update information in the Startup... area of the app (update the app's title, which includes a version number), that would be excellent.
Is this viable? I have played around with it, and started to get the ahold of some of the objects to required to manipulate the foreign queries, forms and reports, but never quite got it to work.
Any ideas, suggestions, assistance would be greatly appreciated. Thanks much!!!
(Please note, I'm off to my day job now, and won't have access to EE until tonight, so responses will be in the evening - thanks for your patience!)
Start Free Trial
