470,821 Members | 1,938 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,821 developers. It's quick & easy.

Changing a line in an access 2000 module

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
Dec 12 '07 #1
4 1269

<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
Dec 12 '07 #2
On Dec 12, 3:30 pm, "Arno R" <arracomn_o_s_p_...@planet.nlwrote:
<alanmcar...@gmail.comschreef 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.
Dec 12 '07 #3

<al*********@gmail.comschreef in bericht news:ca**********************************@x69g2000 hsx.googlegroups.com...
On Dec 12, 3:30 pm, "Arno R" <arracomn_o_s_p_...@planet.nlwrote:
><alanmcar...@gmail.comschreef 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
Dec 12 '07 #4
Arno R wrote:
<al*********@gmail.comschreef in bericht news:ca**********************************@x69g2000 hsx.googlegroups.com...
>>On Dec 12, 3:30 pm, "Arno R" <arracomn_o_s_p_...@planet.nlwrote:
>>><alanmcar...@gmail.comschreef 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.
Dec 13 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Zippy | last post: by
8 posts views Thread by Phil Reynolds | last post: by
11 posts views Thread by jo3c | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.