SCENARIO:
Application originally developed in Access 97 several years ago.
Worked with no problem until recent change from Novell to Active
Directory.
PROBLEM:
Application was converted from Access 97 to Access 2003.
It WORKS on machines running Windows XP
It FAILS on machines running Windows 2000 as below:
In the Form_Load event of one of the forms (which contains a number of
subforms) the following lines appear:
Forms![frmPartDetails]![fsubNHA_Details].Form.RecordSou rce
= "qryPart_Detail s_frm_NHA"
Forms![frmPartDetails]!
[fsubEndUnit_Det ails].Form.RecordSou rce =
"qryPart_Detail s_frm_End_Unit"
When the second line is hit it prompts for a parameter thus:
Forms!frmPartDe tails!fsubNHA_D etails!NHA.Text
This problem does not occur on Windows XP machines.
In order to test this reasonably thoroughly, I copied the code onto a
pen drive and installed it on three machines running XP. They all
worked fine. I then copied it to three machines running Windows 2K
and they all failed with the same problem.
The answer, obviously, is to upgrade all Windows 2000 machines to XP.
But what is the reason that this doesn't work? Is it an
incompatibility between Access 2003 and Windows 2000?
Thanks
Edward 3 1744
When you open a form, Access must it and its subforms into memory. One of
the 2 subforms loads before the other. If you have a dependency that assumes
the other subform is loaded, you can get caught short if Access loads them
in the other order.
Since this happens only when the form is loading, you might be able to work
around the problem by adding error handling, and ignoring the specific error
that occurs when the form first loads.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<te********@hot mail.comwrote in message
news:11******** *************@e 65g2000hsc.goog legroups.com...
SCENARIO:
Application originally developed in Access 97 several years ago.
Worked with no problem until recent change from Novell to Active
Directory.
PROBLEM:
Application was converted from Access 97 to Access 2003.
It WORKS on machines running Windows XP
It FAILS on machines running Windows 2000 as below:
In the Form_Load event of one of the forms (which contains a number of
subforms) the following lines appear:
Forms![frmPartDetails]![fsubNHA_Details].Form.RecordSou rce
= "qryPart_Detail s_frm_NHA"
Forms![frmPartDetails]!
[fsubEndUnit_Det ails].Form.RecordSou rce =
"qryPart_Detail s_frm_End_Unit"
When the second line is hit it prompts for a parameter thus:
Forms!frmPartDe tails!fsubNHA_D etails!NHA.Text
This problem does not occur on Windows XP machines.
In order to test this reasonably thoroughly, I copied the code onto a
pen drive and installed it on three machines running XP. They all
worked fine. I then copied it to three machines running Windows 2K
and they all failed with the same problem.
The answer, obviously, is to upgrade all Windows 2000 machines to XP.
But what is the reason that this doesn't work? Is it an
incompatibility between Access 2003 and Windows 2000?
Thanks
Edward
On 3 Apr, 08:44, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
When you open a form, Access must it and its subforms into memory. One of
the 2 subforms loads before the other. If you have a dependency that assumes
the other subform is loaded, you can get caught short if Access loads them
in the other order.
Since this happens only when the form is loading, you might be able to work
around the problem by adding error handling, and ignoring the specific error
that occurs when the form first loads.
I tried that, and it didn't work because the second form depends on a
value that exists in a control on the first form, which is not
available when it's run on Windows 2000. So although I can bypass the
run-time error the containing form, when loading is complete, is
useless.
What I really want to know is why this should work as expected under
XP but not W2k. I suspect that it is a library issue.
Thanks
Edward
Try placing a doevents command between the two lines....
It might very well be a threading issue, and those NT machines behave a bit
different...
I had a few threading issues pop up when converting from a97 to a2003.
It is a guess on my part..but, give it a try...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: gregory_may |
last post by:
I have an application I created called "JpegViewer.exe". It simply loads a
Jpeg file and displays in on the screen. It works great, in my lab.
When I am using it at a customer site, things change. Occasionally, it
blows up with an Application Exception. It seems to only die at the
customer site
|
by: Andy |
last post by:
Hi !
I have many simple, low-tech database applications spread throughout my
organization that I developed in Access 2K..
Most have ODBC for Oracle connections ( read only ) to our principal
application ( a mid size hospital's ADT software ).
My current version of Access is 2000.
I must now decide wether or not to install Access2003 on the PC that I use
to develop these applications.
The users will be converted to 3000 over the next 6...
|
by: Yang Pang |
last post by:
I have a project where the GUI is in VB.NET, the libraries
in unmanaged C++ which is wrapped in managed C++ and
compiled as DLL.
The application runs fine on Windows 2000 with VC++
development environment installed, but fails to load on
any Windows 2000 system with only the .NET Framework
(tried .NET Framework SDK too) installed.
Tried suggestions given in "Mixed DLL Loading Problem"
|
by: Steve Buster |
last post by:
All right, I have read every forum, newsgroup etc about
this issue and no one seems to know how to fix it. I am
getting a "Server Application Unavailable" exception
running my .NET 1.1 application. I use W2K SP4 and have
applied the hot Fix KB824146 and KB824105, both IE fixes.
I don't have VS installed because this is a Quality
Environment. I do have .NET SDK and .NET 1.1 Runtime
installed. I can't change my APSNET user to run as...
|
by: Vaap |
last post by:
I did lot of googling to see if I can solve the SQL server not found
problem while trying to run ASP.Net community starter kit from an XP
machine to Windows 2003 server hosting SQL server 2000 database. Tried
all possible combinations but it still fails.
I have Windows 2003 server having SQL Server 2000 installed with SP2.
The installation went Ok on a XP professional machine and I was able
to create database and user logins etc on...
| |
by: Anbu |
last post by:
Sorry for cross posting the query. But I need a resolution as early as
possible.
I have developed an application to authenticate the user based on LDAP
Search and authentication.
The Windows application that was developed using C# works fine. But it
fails when I convert this as a DLL or Web Service. I need to host the
application on a server to use the result across different applications
and on different clients.
|
by: adnaan.khalid |
last post by:
Hi,
I have an web site application developed in ASP .NET 2.0. This
application consumes a COM dll (which needs to be registered in the
server- regsvr32 utility) for a functionality. The whole setup works
fine in the test system running Windows 2000 and IIS 5.0 with .NET
Framework 2.0 (Obvious enuf!!! )
Although the whole setup fails in the production system which is
running Windows 2003 server with IIS 6.0.
|
by: snare88 |
last post by:
I have a question regarding a VB.NET 2003 application which was built
on a Windows XP machine with Office 2002 installed. The software does
some interfacing with Microsoft Excel. I now want to run this
application on a Windows 2000 machine with Office 2003 installed.
However, it is not functioning correctly. The application DOES work
on a Windows XP machine running Office 2003. I am referencing the
"Microsoft Excel 10.0 Object...
|
by: robertgregson |
last post by:
Using C#, .NET3.5, Visual Studio 2008 and WCF on Windows VISTA SP1, I have written a service, service host (as a C# console application) and a client.
The service uses Microsoft.Office.Interop.Excel.Application to access an Excel file on the local hard drive, opens it (using Application.Workbooks.Open), reads out some data and the provides said data to the client.
Everything works perfectly when the Service Host is a C# console...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| | |