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)
8  1189 
Les Desser <Ne*******@dess ergroup.comwrot e in
news:Ht******** ******@dessergr oup.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
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
In article <i%YFg.426860$i F6.241797@pd7tw 2no>, Albert D. Kallal
<Pl************ *******@msn.com Sun, 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)
In article <Xn************ **********@66.1 50.105.47>, Bob Quintal
<rq******@sPAmp atico.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)
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*******@dess ergroup.comwrot e in message
news:Ht******** ******@dessergr oup.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)
In article <DK************ ***@newssvr27.n ews.prodigy.net >, ByteMyzer
<sb*@news.sf.sb cglobal.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&di splaylang=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)
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
In article <C75Gg.428024$M n5.128200@pd7tw 3no>, Albert D. Kallal
<Pl************ *******@msn.com Sun, 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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: James Kupernik |
last post by:
couple weeks ago I posted about an random access denied error I was getting
with mysql. Well someone suggested I try it without using a password, which
I did, and it worked great! No errors, but as soon as I pass it a password,
I start to get the random access denied errors. Now it only happens every so
often, but enough where it's annoying!
If anyone has any ideas about this i would LOVE to hear them
Thanks!
|
by: greeningster |
last post by:
I have written an application in Visual C++ for a customer but it seems
to crash randomly.
Could anyone give me any help on how I could track this down ?
Also, there appears there might be memory leaks too. How can i track
these down ?
|
by: akhare1 |
last post by:
OK, before I start, let me clarify a few things here. This is not the
run of the mill failure to read a registry key while trying to write
to the Event Log.
Here's our setup:
a) IIS 6.0 server w/ SharePoint installed
b) ASP.NET application w/ NTLM authentication running under an account
(application pool) with ADMIN privileges on the local box.
c) We are NOT using impersonation
|
by: Maziar Aflatoun |
last post by:
Hi everyone,
I have the following code in my class method
TheSeed = (int)DateTime.Now.Ticks;
Random rndNum = new Random(TheSeed);
RandNum = rndNum.Next(0, TotalRows);
Debug.WriteLine("RandNum:" + RandNum + " Low:0 " + "High:" + TotalRows);
My page gets called everytime and these are the values that I'm getting for
|
by: Marty Cruise |
last post by:
I successfully deploy my application to 20 domain users. Only one new user
is giving me a problem, although he can access all domain resources.
When he clicks the installation link on the publish page, Framework 2.0
installs successfully, but then the application installation fails during the
"Verifying Application Requirements" process. Can anyone help me figure out
how to solve this? Error is as follows.
PLATFORM VERSION INFO...
| | |
by: Frav |
last post by:
The Reps team have been experiencing that Access 2002 unexpectedly
quits
while working and also lots of Corruption Failures and "Record lock
can not
update" messages since the upgrade from Windows 2000 and Access 200 to
Windows XP and Access 2002 (XP) was done.
Now, they are working and at anytime in anywhere of the application
access
unexpectedly quits with no error messages and the info that was being
entered
|
by: JimLad |
last post by:
Hi,
First of all I didn't design this website, but I have been asked to
fix it with the minimum fuss!
Website is using .NET on IIS6 with an Excel Interop to produce
reports. The website impersonates the user and anonymous access is
disabled. Once excel is loaded it stays loaded for the life of the web
application and is accessed through an application variable. As I say,
I didn't design this! Usage of website is very low - once a...
|
by: RobertKKoller |
last post by:
I have an Access frontend that connects to an Oracle9i database backend that is set up with a DSN using the Oracle 8 ODBC Driver. In general, everything works perfectly, but randomly (I say random since I can't find any cause) when I open the Access application and open a form or table that connects to Oracle, I get the error message "ODBC - Connection to 'DSN Name' failed". Then to fix this, all I have to do is use the Linked Table Manager to...
|
by: Andrus |
last post by:
VS2008 .net 3.5 WinForms application contains only managed code.
At random places my application causes exception below.
env: Vista SP1.
How to fix ?
Andrus.
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
