Patching a Microsoft Access Program
I believe that Tony's Toews free autoFE updater should
also do what you're looking for. Although it is created
to update frontends, I believe that it'll also do what you
want. It's a GREAT utility.
http://www.granite.ab.ca/access/autofe.htm
-hai
Quote:
>-----Original Message-----
>Hello everyone,
>I have an access project deployed in dozens of locations,
>and as new features or fixes become available I need to
>send an update patch.
>The only way ive figrued out is to create a new database
>with the corrected table, query, form, report, etc. and
>use a "DoCmd.TransferDatabase acExport" command to send
>the file over, which seemed to work.
>However if i try to send over multiple tables and forms
>and or large forms, i sometimes get the following error;
>runtime error "3420"
>Object invalid or no longer set.
>The strange thing is if i just keep trying running it a
>few times, eventually it will work, but i hate having
>calls come in and havignt ot ell them to just keep trying
>until it works. Any ideas why this is happening and how
>to make it work on the first try? I tried having it
>repeat itself automatically when the error happens, but
>in some cases it was crashing the program altogether.
>thanks!
>.
