473,387 Members | 1,722 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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 1354

<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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Zippy | last post by:
Some months ago, we requested help from this newsgroup on how to replace the library reference of a database with another library reference, prior to creating an MDE. I got the following answer...
13
by: Peter | last post by:
Can anyone tell me how to change the data type of a field in a table created with a make table query? The field is a binary and must be changed to text. alternately does anyone know how to specify...
16
by: StenKoll | last post by:
Help needed in order to create a register of stocks in a company. In accordance with local laws I need to give each individual share a number. I have accomplished this by establishing three tables...
7
by: Alex | last post by:
Hi all, I've found a module that I think will help me combine fields properly, but I'm unsure how to add or use it with Access 2000. Below is the module I'd like to add: ...
17
by: blufox | last post by:
Hi All, Can i change the execution path of methods in my process at runtime? e.g a()->b()->c()->d()->e() Now, i want execution to be altered at runtime as -
8
by: Phil Reynolds | last post by:
I have a single text box (a large one) in a form that pops up. I want the text box to change size as the user changes the size of the form. However, doing me.txtbox.width = me.width doesn't work,...
4
by: hawaiijeff | last post by:
Is there any way to stop access (Access 2000) from changing the syntax of my SQL queries? For example, I don't always put the table_name. because it makes it hard to read. Access doesn't have a...
11
by: jo3c | last post by:
hi everybody im a newbie in python i need to read line 4 from a header file using linecache will crash my computer due to memory loading, because i am working on 2000 files each is 8mb ...
16
by: John | last post by:
I am looking for VBA code that will work with Access 2003 to enable dragging and dropping a file/folder name from Windows XP Explorer into an Access form's text box. This is a common functionality...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.