Updating Forms, Reports and VBA components

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JMG - 29 Jul 2005 09:17 GMT

I have an application I deisgned a year ago (A2K) and over the year the data
has been entered and stored. Is there a way to to send an application that
will update/replace the forms, reports and modules? I would rather send
something that would auto-update the database as cannot be sent to me for me
to import the new forms, reports and modules.

Many thanks for your suggestions.
JMG

Reply to this Message

Alex Dybenko - 29 Jul 2005 12:43 GMT

Hi,
you can make a new version, with separate file for tables, then you ship
this new version and ask users to link if you their old application with
data. this is the best (and perhaps the only one) approach

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

>I have an application I deisgned a year ago (A2K) and over the year the
>data
[quoted text clipped - 6 lines]
> Many thanks for your suggestions.
> JMG

Reply to this Message

David C. Holley - 29 Jul 2005 14:27 GMT

Additionally, if you get the full path to your user's backend, it might
be possible to create a similar path on your PC. Then when you connect
the Front End on your PC to the backend using this path, the links will
be captured by Access. Then when you send the front end to the users,
all they should have to do is open the file. If that isn't a possibilty,
the other option would be to manually update the path information just
before shipping the front end.

> Hi,
> you can make a new version, with separate file for tables, then you ship
> this new version and ask users to link if you their old application with
> data. this is the best (and perhaps the only one) approach

Reply to this Message