Changing a line in an access 2000 module

[alanmcarter]

we have 2 Access Applications. One is in Access 97, the other in
2000.

With Access 97 I was able to replace a module that contains an old web
address using docmd.TransferDatabase.

When I tried it with Access 2000 (it's the same module) it crashes the
application on load. I've searched around and have found that this is
a known bug. Unfortunately, I have this deployed to several customers
using the runtime, so I can't go with the workaround.

I have been tasked with changing this line, so I was wondering if I
could do it w/ a simple VB app. . . but I haven't the foggiest idea
where to start.

Could someone help point me in the right direction?

Thanks,
Alan

[Arno R]

<al*********@gmail.comschreef in bericht news:b7**********************************@p69g2000 hsa.googlegroups.com...

we have 2 Access Applications. One is in Access 97, the other in
2000.

With Access 97 I was able to replace a module that contains an old web
address using docmd.TransferDatabase.

When I tried it with Access 2000 (it's the same module) it crashes the
application on load. I've searched around and have found that this is
a known bug. Unfortunately, I have this deployed to several customers
using the runtime, so I can't go with the workaround.

I have been tasked with changing this line, so I was wondering if I
could do it w/ a simple VB app. . . but I haven't the foggiest idea
where to start.

Could someone help point me in the right direction?

Thanks,
Alan

Can't you simply send them an updated app (FE) ??
I am assuming you did split the app in a seperate frontend and backend .... ??

Arno R

[alanmcarter]

On Dec 12, 3:30 pm, "Arno R" <[e-mail]:

<[e-mail] in berichtnews:b7**********************************@p 69g2000hsa.googlegroups.com...

we have 2 Access Applications. One is in Access 97, the other in
2000.

With Access 97 I was able to replace a module that contains an old web
address using docmd.TransferDatabase.

When I tried it with Access 2000 (it's the same module) it crashes the
application on load. I've searched around and have found that this is
a known bug. Unfortunately, I have this deployed to several customers
using the runtime, so I can't go with the workaround.

I have been tasked with changing this line, so I was wondering if I
could do it w/ a simple VB app. . . but I haven't the foggiest idea
where to start.

Could someone help point me in the right direction?

Thanks,
Alan

Can't you simply send them an updated app (FE) ??
I am assuming you did split the app in a seperate frontend and backend ... ??

Arno R

Well, i could (and yes it is split) but the front end is still pretty
big (20+ mb) so the powers that be want an e-mailable patch.

[Arno R]

<al*********@gmail.comschreef in bericht news:ca**********************************@x69g2000 hsx.googlegroups.com...

On Dec 12, 3:30 pm, "Arno R" <[e-mail]:

><[e-mail] in berichtnews:b7**********************************@p 69g2000hsa.googlegroups..com...

we have 2 Access Applications. One is in Access 97, the other in
2000.

With Access 97 I was able to replace a module that contains an old web
address using docmd.TransferDatabase.

When I tried it with Access 2000 (it's the same module) it crashes the
application on load. I've searched around and have found that this is
a known bug. Unfortunately, I have this deployed to several customers
using the runtime, so I can't go with the workaround.

I have been tasked with changing this line, so I was wondering if I
could do it w/ a simple VB app. . . but I haven't the foggiest idea
where to start.

Could someone help point me in the right direction?

Thanks,
Alan

Can't you simply send them an updated app (FE) ??
I am assuming you did split the app in a seperate frontend and backend ... ??

Arno R

Well, i could (and yes it is split) but the front end is still pretty
big (20+ mb) so the powers that be want an e-mailable patch.

Hmm. pretty big indeed ....
I wonder what kind of app that is ... (Sure you have no tables ??)
My 'biggest' app is about 9 Mb as mdb; distributed as mde it is about 5 Mb; zipped it is about 1,5 Mb

So how do you distribute updates if you are unable to mail them ??

Arno R

[Salad]

Arno R wrote:

<al*********@gmail.comschreef in bericht news:ca**********************************@x69g2000 hsx.googlegroups.com...

>>On Dec 12, 3:30 pm, "Arno R" <[e-mail]:

>>><[e-mail] in berichtnews:b7**********************************@p 69g2000hsa.googlegroups.com...


we have 2 Access Applications. One is in Access 97, the other in
2000.

With Access 97 I was able to replace a module that contains an old web
address using docmd.TransferDatabase.

When I tried it with Access 2000 (it's the same module) it crashes the
application on load. I've searched around and have found that this is
a known bug. Unfortunately, I have this deployed to several customers
using the runtime, so I can't go with the workaround.

I have been tasked with changing this line, so I was wondering if I
could do it w/ a simple VB app. . . but I haven't the foggiest idea
where to start.

Could someone help point me in the right direction?

Thanks,
Alan

Can't you simply send them an updated app (FE) ??
I am assuming you did split the app in a seperate frontend and backend ... ??

Arno R

Well, i could (and yes it is split) but the front end is still pretty
big (20+ mb) so the powers that be want an e-mailable patch.

Hmm. pretty big indeed ....
I wonder what kind of app that is ... (Sure you have no tables ??)
My 'biggest' app is about 9 Mb as mdb; distributed as mde it is about 5 Mb; zipped it is about 1,5 Mb

So how do you distribute updates if you are unable to mail them ??

Arno R

Can runtimes modify code?

20 meg? Unless the user is using dial-up 20 meg won't take long
unzipped. Zipped will be even smaller.

After that I'd use Tony Toews AutoFe to keep life simple.