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

Random failure of Access 97 Application on XP

P: n/a
I have a large application in A97 that has recently started to fail
randomly on startup.

The problem is always on XP (W2K is never a problem). It can work for
weeks or months and then bingo - it fails on startup with a message like
"unknown function CurrentUser" which is coming from an add-in of ours
that is loaded after the main application.

The only solution I currently have is to go back to an old version which
does not seem to suffer from this problem (though there are no
significant differences between the versions)

The application consists of a master application and several add-ins -
all compiled into .mde

I recently installed three identical Dell PCs at a new client and loaded
the application. Worked fine for a few days and then two of them
failed. I re-installed the application and one worked for a short while
the others still failed.

I took one of the failing machines back to my office, connected it to my
network and loaded the client's data onto my server (both mine and
client's servers running W2K server) and it never ever failed - tried it
dozens of times! Maybe I have a nicer office wallpaper! :(

I obviously need to identify what it is that may be causing this
problem. I wonder whether changing references to a newer version may
help.

Currently I have selected:

Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library

plus my own add-ins.

I see that on the list is shown

Microsoft DAO 3.6 Object Library

Would trying this in place of 3.51 be advisable?[*] I'm not sure
where this version came from. Is it likely that all my clients would
have this version installed? Some only have Office 97 SR2 installed.
[*] I have a vague feeling that I have tried 3.6 some time in the past
but had problems - cannot be certain.

Any suggestions on how to solve this would be most appreciated.

Thanks.
--
Les Desser
(The Reply-to address IS valid)
Aug 20 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a
Les Desser <Ne*******@dessergroup.comwrote in
news:Ht**************@dessergroup.com:
I have a large application in A97 that has recently started to
fail randomly on startup.

The problem is always on XP (W2K is never a problem). It can
work for weeks or months and then bingo - it fails on startup
with a message like "unknown function CurrentUser" which is
coming from an add-in of ours that is loaded after the main
application.
Any suggestions on how to solve this would be most
appreciated.

Thanks.
This may sound silly, but check the anti-virus program logs. It
may be that the AV thinks there's a virus it tries to heal.

--
Bob Quintal

PA is y I've altered my email address.

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

Aug 20 '06 #2

P: n/a
Is this a single user application, or do you ever allow MORE then one person
into the application?

If the application is multi-user, then you been lucky to not have problems.
You need to split the application, and then place the compiled mde on EACH
pc...

I not only TELL YOU why you need to split, but also explain why you split
for reasons of reliability here:
http://www.members.shaw.ca/AlbertKal...plit/index.htm

Don't allow multiple users into the same mde file....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 20 '06 #3

P: n/a
In article <i%YFg.426860$iF6.241797@pd7tw2no>, Albert D. Kallal
<Pl*******************@msn.comSun, 20 Aug 2006 12:57:50 writes
>Is this a single user application, or do you ever allow MORE then one
person into the application?
Multi-user
>
If the application is multi-user, then you been lucky to not have
problems. You need to split the application, and then place the
compiled mde on EACH pc...
The application is split.
--
Les Desser
(The Reply-to address IS valid)
Aug 20 '06 #4

P: n/a
In article <Xn**********************@66.150.105.47>, Bob Quintal
<rq******@sPAmpatico.caSun, 20 Aug 2006 09:58:25 writes
>This may sound silly, but check the anti-virus program logs. It may be
that the AV thinks there's a virus it tries to heal.
A thought, but all my clients use the same AV so I do not think it is
that.
--
Les Desser
(The Reply-to address IS valid)
Aug 20 '06 #5

P: n/a
Did you download and install Office 97 Service Release 2b? This is an
absolute must if you are going to run Office 97 on Windows XP.

"Les Desser" <Ne*******@dessergroup.comwrote in message
news:Ht**************@dessergroup.com...
I have a large application in A97 that has recently started to fail
randomly on startup.

The problem is always on XP (W2K is never a problem). It can work for
weeks or months and then bingo - it fails on startup with a message like
"unknown function CurrentUser" which is coming from an add-in of ours
that is loaded after the main application.

The only solution I currently have is to go back to an old version which
does not seem to suffer from this problem (though there are no
significant differences between the versions)

The application consists of a master application and several add-ins -
all compiled into .mde

I recently installed three identical Dell PCs at a new client and loaded
the application. Worked fine for a few days and then two of them
failed. I re-installed the application and one worked for a short while
the others still failed.

I took one of the failing machines back to my office, connected it to my
network and loaded the client's data onto my server (both mine and
client's servers running W2K server) and it never ever failed - tried it
dozens of times! Maybe I have a nicer office wallpaper! :(

I obviously need to identify what it is that may be causing this
problem. I wonder whether changing references to a newer version may
help.

Currently I have selected:

Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library

plus my own add-ins.

I see that on the list is shown

Microsoft DAO 3.6 Object Library

Would trying this in place of 3.51 be advisable?[*] I'm not sure
where this version came from. Is it likely that all my clients would
have this version installed? Some only have Office 97 SR2 installed.
[*] I have a vague feeling that I have tried 3.6 some time in the past
but had problems - cannot be certain.

Any suggestions on how to solve this would be most appreciated.

Thanks.
--
Les Desser
(The Reply-to address IS valid)

Aug 20 '06 #6

P: n/a
In article <DK***************@newssvr27.news.prodigy.net>, ByteMyzer
<sb*@news.sf.sbcglobal.netSun, 20 Aug 2006 18:21:23 writes
>Did you download and install Office 97 Service Release 2b? This is an
absolute must if you are going to run Office 97 on Windows XP.
Possibly did some time in the past on an earlier PC but probably not on
the latest. Certainly did not do it on client machines.

Thank you - I will investigate.
--------------

Some time later ...

Found it at

<http://www.microsoft.com/downloads/d...efd7842-602e-4
2b0-89d2-6be39f1167c1&displaylang=en>

Installed it on my machine. Not very helpful that the About screen -
still shows SR2 without the b. Any way to check it has been installed?
--
Les Desser
(The Reply-to address IS valid)
Aug 20 '06 #7

P: n/a
Hum...ok, that sounds quite good.
Have you tried placing a mde, not a mdb on each computer?

I assuming in addition to splitting, you place the front end on each pc.

I would also try distribution a mde, as they tend to be MORE reliable, and
CAN NOT become un-compiled like a mdb frequently does/can.

So, try placing a mde on each machine, and see how that goes....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 20 '06 #8

P: n/a
In article <C75Gg.428024$Mn5.128200@pd7tw3no>, Albert D. Kallal
<Pl*******************@msn.comSun, 20 Aug 2006 22:12:50 writes
>Hum...ok, that sounds quite good.
Not sure what you are referring to but I will take it as confirmation
that whatever I do is good :)
>
Have you tried placing a mde, not a mdb on each computer?
I only distribute mde's
>
I assuming in addition to splitting, you place the front end on each pc.
I do - the source (mdb, mda) never leaves the office.
-------------

Taking on board my own idea and ByteMyzer's suggestion I have changed
references to DAO 3.6 and installed SR2b. I will try rolling that out
and seeing if that improves matters.

--
Les Desser
(The Reply-to address IS valid)
Aug 21 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.