By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Changing a line in an access 2000 module

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a

<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

P: n/a
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

P: n/a

<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

P: n/a
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.