Access mde files

[Bigpond News]

Work at a large site - 1000+ PC's. Mixture of Win98 & WinXP. Majority of
applications using Access 97.

If I compile the Acc97 application on a Win98 PC, the .mde will run
perfectly on both Win98 and WinXP PC's. However, if I compile on a WinXP
PC, the application doesn't run correctly on Win98 PC's.

While I guess a Windows issue, does anyone know the offending files and even
better, how to resolve it ? Otherwise I need to compile on a Win98 PC
until the last PC is upgraded to WinXP.

Regards

Peter

[Larry Linson]

"Bigpond News" <ma********@yah oo.com.au> wrote

While I guess a Windows issue, does anyone
know the offending files and even better, how
to resolve it ? Otherwise I need to compile on
a Win98 PC until the last PC is upgraded to WinXP.

I don't know what causes the problem, but you seem to have the answer.

['69 Camaro]

Hi, Peter.

However, if I compile on a WinXP
PC, the application doesn't run correctly on Win98 PC's.
There are probably thousands of situations that can come under the heading
of "the application doesn't run correctly." Do you want us to begin at the
top of Aaron Kempf's list and iterate through his list at the rate of one
per post to start narrowing down the problem, or would you prefer to hurry
things up a bit by describing how the application isn't meeting your
expectations, listing any error codes and descriptions the Windows 98
computers are showing, and listing which service packs have been applied for
Access, Jet 3.5, and MDAC? (These service packs should be the same on all
computers accessing the application.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Bigpond News" <ma********@yah oo.com.au> wrote in message
news:Hh******** *********@news-server.bigpond. net.au... Work at a large site - 1000+ PC's. Mixture of Win98 & WinXP. Majority
of
applications using Access 97.

If I compile the Acc97 application on a Win98 PC, the .mde will run
perfectly on both Win98 and WinXP PC's. However, if I compile on a WinXP
PC, the application doesn't run correctly on Win98 PC's.

While I guess a Windows issue, does anyone know the offending files and
even
better, how to resolve it ? Otherwise I need to compile on a Win98 PC
until the last PC is upgraded to WinXP.

Regards

Peter

[Bigpond News]

Thanks for the attitude.

If you have nothing to say that may be of assistance, stick to your own web
site and don't waste the time of others.

Peter


"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAM> wrote in
message news:O4******** *************** *******@adelphi a.com...

Hi, Peter.

However, if I compile on a WinXP
PC, the application doesn't run correctly on Win98 PC's.
There are probably thousands of situations that can come under the heading
of "the application doesn't run correctly." Do you want us to begin at

the top of Aaron Kempf's list and iterate through his list at the rate of one
per post to start narrowing down the problem, or would you prefer to hurry
things up a bit by describing how the application isn't meeting your
expectations, listing any error codes and descriptions the Windows 98
computers are showing, and listing which service packs have been applied for Access, Jet 3.5, and MDAC? (These service packs should be the same on all
computers accessing the application.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Bigpond News" <ma********@yah oo.com.au> wrote in message
news:Hh******** *********@news-server.bigpond. net.au...

Work at a large site - 1000+ PC's. Mixture of Win98 & WinXP. Majority of
applications using Access 97.

If I compile the Acc97 application on a Win98 PC, the .mde will run
perfectly on both Win98 and WinXP PC's. However, if I compile on a WinXP PC, the application doesn't run correctly on Win98 PC's.

While I guess a Windows issue, does anyone know the offending files and
even
better, how to resolve it ? Otherwise I need to compile on a Win98 PC
until the last PC is upgraded to WinXP.

Regards

Peter

[Bigpond News]

Thanks Larry

Was hoping for a "quick" solution but as you say, I at least have a
solution.

Regards

Peter

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:Dw%kg.6958 $1G2.5007@trndd c06...

"Bigpond News" <ma********@yah oo.com.au> wrote

> While I guess a Windows issue, does anyone
> know the offending files and even better, how
> to resolve it ? Otherwise I need to compile on
> a Win98 PC until the last PC is upgraded to WinXP.

I don't know what causes the problem, but you seem to have the answer.

[james.igoe]

It sounds like a binding issue. The lower version you compile with is
simply upgraded when run on the newer OS version, but the newer version
can't be downgraded since the older version has no concept of what to
downgrade to. I had an issue recently at a client - I had two (2)
PC's, one with Office 2000 and one with Office 2003 - and ran into a
similar issue. The reference libraries were different for the
versions. The problem was solved by using late binding for the
objects.

Instead of declaring an Excel worksheet, one would have to DIM and
object, then later in the code set the object to an Excel worksheet.
Early binding runs faster but creates problems when you have a mixed
environment. I had to change every reference in the code to use late
binding, and it solved the problem. It will also make the application
future-proof, regarding OS, and Office upgrades.

Regards,

James Igoe

646.303.2584 || ja********@gmai l.com ||
http://code.comparative-advantage.com

Resume: http://code.comparative-advantage.co...ad_resume.php?
Bigpond News wrote:

Work at a large site - 1000+ PC's. Mixture of Win98 & WinXP. Majority of
applications using Access 97.

If I compile the Acc97 application on a Win98 PC, the .mde will run
perfectly on both Win98 and WinXP PC's. However, if I compile on a WinXP
PC, the application doesn't run correctly on Win98 PC's.

While I guess a Windows issue, does anyone know the offending files and even
better, how to resolve it ? Otherwise I need to compile on a Win98 PC
until the last PC is upgraded to WinXP.

Regards

Peter

[Bob Quintal]

"Bigpond News" <ma********@yah oo.com.au> wrote in
news:dH******** **********@news-server.bigpond. net.au:

Thanks for the attitude.

If you have nothing to say that may be of assistance, stick to
your own web site and don't waste the time of others.

Peter
Peter, the @$$ with the arrogance is whoever posted some vague
generality about "the application doesn't run correctly on Win98
PC's" and expects help. You should apologise to mr Camaro.

If you don't know enough about the problem to describe symptoms
accurately, you are wasting every reader of the newsgroup's
time.

I'm running Access '97 applications (.mdb and .mde) across a
site with Win 98, NT, ME and XP boxes.

I have no knowledge of "the application doesn't run correctly on
Win98 PC's"

..
"'69 Camaro"
<Fo************ **************@ Spameater.orgZE RO_SPAM> wrote in
message news:O4******** *************** *******@adelphi a.com...

Hi, Peter.

> However, if I compile on a WinXP
> PC, the application doesn't run correctly on Win98 PC's.

There are probably thousands of situations that can come
under the heading of "the application doesn't run correctly."
Do you want us to begin at

the

top of Aaron Kempf's list and iterate through his list at the
rate of one per post to start narrowing down the problem, or
would you prefer to hurry things up a bit by describing how
the application isn't meeting your expectations, listing any
error codes and descriptions the Windows 98 computers are
showing, and listing which service packs have been applied

for

Access, Jet 3.5, and MDAC? (These service packs should be
the same on all computers accessing the application.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips
and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html
for contact info.
"Bigpond News" <ma********@yah oo.com.au> wrote in message
news:Hh******** *********@news-server.bigpond. net.au...

> Work at a large site - 1000+ PC's. Mixture of Win98 &
> WinXP. Majority > of
> applications using Access 97.
>
> If I compile the Acc97 application on a Win98 PC, the .mde
> will run perfectly on both Win98 and WinXP PC's. However,
> if I compile on a WinXP > PC, the application doesn't run correctly on Win98 PC's.
>
> While I guess a Windows issue, does anyone know the
> offending files and even
> better, how to resolve it ? Otherwise I need to compile
> on a Win98 PC until the last PC is upgraded to WinXP.
>
> Regards
>
> Peter
>
>

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Lyle Fairfield]

Bigpond News wrote:

If you have nothing to say that may be of assistance, stick to your own web
site and don't waste the time of others.
Peter

Gunny writes a lot of very good stuff here. Many times I agree with
him. This is one of them.

['69 Camaro]

Hello, Peter Henderson.

Thanks for the attitude.
If you think that the analogy in my reply of going through the list of
thousands of complaints about Access -- like the list of thousands of
complaints you might possibly have, but you've kept secret as to which
ones -- constitutes an attitude, then that's your prerogative. I and many
others volunteer our time to help those who ask for help, but our time is a
limited resource, and by posting a question with a vague description of your
problem, you're less likely to get helpful responses from us to solve this
problem, one that you still haven't solved yourself in more than two years:

http://groups.google.com/group/comp....192e676?hl=en&

The last time you posted a similar question, you received zero responses,
most likely because it, too, was a vague question. Your problem is not
uncommon, and there are a number of experts who have experience with MDE's
on multiple OS's. Any of them could have replied to your post two years
ago, yet none took the time. That should tell you something. Please see
the following Web page:

http://www.mvps.org/access/netiquette.htm

Pay particular attention to items 7, 8, and 10 in the "Asking questions the
right way" section.
If you have nothing to say that may be of assistance
I and the others have plenty to say that may assist you, but without your
revealing details of what is happening and listing the service pack levels
installed on your workstations, the best I can offer is to suggest that you
ensure that all workstations have the same service packs installed, because
different service packs result in different sets of behaviors. At this
point, anything else I or others might suggest is just speculation as to
what your problem is. Perhaps you'll rectify this by providing additional
information about what's going wrong.
stick to your own web
site
Perhaps this was intended as an insult. If so, you missed the mark, because
it signifies that you noticed a Web site of Access tips and tutorials, which
is the intent of that Web site. I can only respond with "Thank you for
noticing our work." ;-)
and don't waste the time of others.
I know you think that I'm wasting _your_ time, but likely thousands of
people have already read your two posted questions, yet we haven't helped
you solve your problem in two years, because you're keeping a secret of what
the problem actually is. You've described an effect of the problem, "the
application doesn't run correctly" when compiled on a Windows XP
workstation, but we can't help you eliminate the causes unless you reveal
the symptoms. If this thread doesn't eventually provide a solution, then
the efforts exerted to post in and read these two threads were pretty much a
waste of time. So it's up to you to get the ball rolling, and we'll take it
from there.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Bigpond News" <ma********@yah oo.com.au> wrote in message
news:dH******** **********@news-server.bigpond. net.au... Thanks for the attitude.

If you have nothing to say that may be of assistance, stick to your own
web
site and don't waste the time of others.

Peter


"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAM> wrote
in
message news:O4******** *************** *******@adelphi a.com...

Hi, Peter.

> However, if I compile on a WinXP
> PC, the application doesn't run correctly on Win98 PC's.

There are probably thousands of situations that can come under the
heading
of "the application doesn't run correctly." Do you want us to begin at

the

top of Aaron Kempf's list and iterate through his list at the rate of one
per post to start narrowing down the problem, or would you prefer to
hurry
things up a bit by describing how the application isn't meeting your
expectations, listing any error codes and descriptions the Windows 98
computers are showing, and listing which service packs have been applied

for

Access, Jet 3.5, and MDAC? (These service packs should be the same on
all
computers accessing the application.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Bigpond News" <ma********@yah oo.com.au> wrote in message
news:Hh******** *********@news-server.bigpond. net.au...

> Work at a large site - 1000+ PC's. Mixture of Win98 & WinXP. Majority > of
> applications using Access 97.
>
> If I compile the Acc97 application on a Win98 PC, the .mde will run
> perfectly on both Win98 and WinXP PC's. However, if I compile on a WinXP > PC, the application doesn't run correctly on Win98 PC's.
>
> While I guess a Windows issue, does anyone know the offending files and
> even
> better, how to resolve it ? Otherwise I need to compile on a Win98 PC
> until the last PC is upgraded to WinXP.
>
> Regards
>
> Peter
>
>

[james.igoe]

If you don't like his manner of presenting, don't respond to his
question.

You don't have to be here, and some don't mind dealing with questions
that are a tad ambiguous, and they can respond.
Regards,

James Igoe

ja********@gmai l.com || http://code.comparative-advantage.com

'69 Camaro wrote:

Hello, Peter Henderson.

Thanks for the attitude.

If you think that the analogy in my reply of going through the list of
thousands of complaints about Access -- like the list of thousands of
complaints you might possibly have, but you've kept secret as to which
ones -- constitutes an attitude, then that's your prerogative. I and many
others volunteer our time to help those who ask for help, but our time is a
limited resource, and by posting a question with a vague description of your
problem, you're less likely to get helpful responses from us to solve this
problem, one that you still haven't solved yourself in more than two years:

http://groups.google.com/group/comp....192e676?hl=en&

The last time you posted a similar question, you received zero responses,
most likely because it, too, was a vague question. Your problem is not
uncommon, and there are a number of experts who have experience with MDE's
on multiple OS's. Any of them could have replied to your post two years
ago, yet none took the time. That should tell you something. Please see
the following Web page:

http://www.mvps.org/access/netiquette.htm

Pay particular attention to items 7, 8, and 10 in the "Asking questions the
right way" section.

If you have nothing to say that may be of assistance

I and the others have plenty to say that may assist you, but without your
revealing details of what is happening and listing the service pack levels
installed on your workstations, the best I can offer is to suggest that you
ensure that all workstations have the same service packs installed, because
different service packs result in different sets of behaviors. At this
point, anything else I or others might suggest is just speculation as to
what your problem is. Perhaps you'll rectify this by providing additional
information about what's going wrong.

stick to your own web
site

Perhaps this was intended as an insult. If so, you missed the mark, because
it signifies that you noticed a Web site of Access tips and tutorials, which
is the intent of that Web site. I can only respond with "Thank you for
noticing our work." ;-)

and don't waste the time of others.

I know you think that I'm wasting _your_ time, but likely thousands of
people have already read your two posted questions, yet we haven't helped
you solve your problem in two years, because you're keeping a secret of what
the problem actually is. You've described an effect of the problem, "the
application doesn't run correctly" when compiled on a Windows XP
workstation, but we can't help you eliminate the causes unless you reveal
the symptoms. If this thread doesn't eventually provide a solution, then
the efforts exerted to post in and read these two threads were pretty much a
waste of time. So it's up to you to get the ball rolling, and we'll take it
from there.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Bigpond News" <ma********@yah oo.com.au> wrote in message
news:dH******** **********@news-server.bigpond. net.au...

Thanks for the attitude.

If you have nothing to say that may be of assistance, stick to your own
web
site and don't waste the time of others.

Peter


"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAM> wrote
in
message news:O4******** *************** *******@adelphi a.com...

Hi, Peter.

> However, if I compile on a WinXP
> PC, the application doesn't run correctly on Win98 PC's.

There are probably thousands of situations that can come under the
heading
of "the application doesn't run correctly." Do you want us to begin at

the

top of Aaron Kempf's list and iterate through his list at the rate of one
per post to start narrowing down the problem, or would you prefer to
hurry
things up a bit by describing how the application isn't meeting your
expectations, listing any error codes and descriptions the Windows 98
computers are showing, and listing which service packs have been applied

for

Access, Jet 3.5, and MDAC? (These service packs should be the same on
all
computers accessing the application.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Bigpond News" <ma********@yah oo.com.au> wrote in message
news:Hh******** *********@news-server.bigpond. net.au...
> Work at a large site - 1000+ PC's. Mixture of Win98 & WinXP.

Majority

> of
> applications using Access 97.
>
> If I compile the Acc97 application on a Win98 PC, the .mde will run
> perfectly on both Win98 and WinXP PC's. However, if I compile on a

WinXP

> PC, the application doesn't run correctly on Win98 PC's.
>
> While I guess a Windows issue, does anyone know the offending files and
> even
> better, how to resolve it ? Otherwise I need to compile on a Win98 PC
> until the last PC is upgraded to WinXP.
>
> Regards
>
> Peter
>
>