I have an Access XP app running over TS with Windows 2000 Server.
There are 5 sites (each with 3 or 4 users) accessing the data file, and each
has its own front end mde on the server. The mde's open exclusively.
When a user at site 'A' prints a report or opens a form, it is called using
something like:
DoCmd.Openrepor t rptname, , , "PropNum = " & gblPropNum
Where the PropNum is a unique ID (byte) for the property for which that site
has access, and gblPropNum is a global variable (byte) which is set once for
each site when the app is opened.
An intermittent problem (twice in 3 months) is occurring where data from a
second site finds its way into a report or a form for the first site.
Is it possible that the global variable could be the cause?
Has anyone else seen anything similar?
--
Bob Darlington
Brisbane
6  1761 
Personnally, I don't use global variables anymore Too unstable anyway. I
suggest that you use an hidden form with controls used as the variable.
"Bob Darlington" <bo*@dpcmanAX.c om.au> wrote in message
news:40******** *************** @news.optusnet. com.au... I have an Access XP app running over TS with Windows 2000 Server.
There are 5 sites (each with 3 or 4 users) accessing the data file, and
each has its own front end mde on the server. The mde's open exclusively.
When a user at site 'A' prints a report or opens a form, it is called
using something like:
DoCmd.Openrepor t rptname, , , "PropNum = " & gblPropNum
Where the PropNum is a unique ID (byte) for the property for which that
site has access, and gblPropNum is a global variable (byte) which is set once
for each site when the app is opened.
An intermittent problem (twice in 3 months) is occurring where data from a
second site finds its way into a report or a form for the first site.
Is it possible that the global variable could be the cause?
Has anyone else seen anything similar?
--
Bob Darlington
Brisbane
In what context do you mean 'unstable'?
I've been using them, albiet in a limited way, for many years and not found
any instability.
My problem now is within the TS environment.
Are you saying that the stability changes when used in TS?
--
Bob Darlington
Brisbane
"Saintor" <sa******@REMOV ETHIShotmail.co m> wrote in message
news:uh******** ************@we ber.videotron.n et... Personnally, I don't use global variables anymore Too unstable anyway.
I suggest that you use an hidden form with controls used as the variable.
"Bob Darlington" <bo*@dpcmanAX.c om.au> wrote in message
news:40******** *************** @news.optusnet. com.au... I have an Access XP app running over TS with Windows 2000 Server.
There are 5 sites (each with 3 or 4 users) accessing the data file, and
each has its own front end mde on the server. The mde's open exclusively.
When a user at site 'A' prints a report or opens a form, it is called
using something like:
DoCmd.Openrepor t rptname, , , "PropNum = " & gblPropNum
Where the PropNum is a unique ID (byte) for the property for which that
site has access, and gblPropNum is a global variable (byte) which is set once
for each site when the app is opened.
An intermittent problem (twice in 3 months) is occurring where data from
a second site finds its way into a report or a form for the first site.
Is it possible that the global variable could be the cause?
Has anyone else seen anything similar?
--
Bob Darlington
Brisbane
"Bob Darlington" <bo*@dpcmanAX.c om.au> wrote in message
news:40******** *************** @news.optusnet. com.au... In what context do you mean 'unstable'?
I've been using them, albiet in a limited way, for many years and not
found any instability.
My problem now is within the TS environment.
Are you saying that the stability changes when used in TS?
The only "instabilit y" that I'm aware of is that an unhandled runtime error
can cause global variables to lose their setting. This doesn't happen in
an MDE though.
I agree with you as I have used them for years with no issues. Most of
mine are set and then used within a short time interval. I might be a
little more worried using a global variable that needs to retain its value
for the entire session, but again, I've never encountered any problems.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
"Bob Darlington" <bo*@dpcmanAX.c om.au> wrote in message news:<40******* *************** *@news.optusnet .com.au>... In what context do you mean 'unstable'?
I've been using them, albiet in a limited way, for many years and not found
any instability.
My problem now is within the TS environment.
Are you saying that the stability changes when used in TS?
--
Bob Darlington
Brisbane
"Saintor" <sa******@REMOV ETHIShotmail.co m> wrote in message
news:uh******** ************@we ber.videotron.n et... Personnally, I don't use global variables anymore Too unstable anyway.
I suggest that you use an hidden form with controls used as the variable.
"Bob Darlington" <bo*@dpcmanAX.c om.au> wrote in message
news:40******** *************** @news.optusnet. com.au... I have an Access XP app running over TS with Windows 2000 Server.
There are 5 sites (each with 3 or 4 users) accessing the data file, and each has its own front end mde on the server. The mde's open exclusively.
When a user at site 'A' prints a report or opens a form, it is called using something like:
DoCmd.Openrepor t rptname, , , "PropNum = " & gblPropNum
Where the PropNum is a unique ID (byte) for the property for which that site has access, and gblPropNum is a global variable (byte) which is set once for each site when the app is opened.
An intermittent problem (twice in 3 months) is occurring where data from a second site finds its way into a report or a form for the first site.
Is it possible that the global variable could be the cause?
Has anyone else seen anything similar?
--
Bob Darlington
Brisbane
I think I remember reading recently in this NG about global variables,
such as strings, losing their values when a run-time error gets caught
by the 'On Error' mechanism. I have seen other situations where the
global value just gets lost mysteriously. You probably don't rely on
On Error as much as he does so you don't detect any 'instability.'
Also, whenever if I use a global string I try to keep the time between
setting it and using it to a minimum.
James A. Fortune
Rick and James,
Thanks for the input.
As you say, as long as all procedures have error handlers, there shouldn't
be a problem with globals.
But I guess my question should be:
"Does anything change when used within a TS session?"
--
Bob Darlington
Brisbane
"Bob Darlington" <bo*@dpcmanAX.c om.au> wrote in message
news:40******** *************** @news.optusnet. com.au... In what context do you mean 'unstable'?
I've been using them, albiet in a limited way, for many years and not
found any instability.
My problem now is within the TS environment.
Are you saying that the stability changes when used in TS?
--
Bob Darlington
Brisbane
"Saintor" <sa******@REMOV ETHIShotmail.co m> wrote in message
news:uh******** ************@we ber.videotron.n et... Personnally, I don't use global variables anymore Too unstable
anyway. I suggest that you use an hidden form with controls used as the variable.
"Bob Darlington" <bo*@dpcmanAX.c om.au> wrote in message
news:40******** *************** @news.optusnet. com.au... I have an Access XP app running over TS with Windows 2000 Server.
There are 5 sites (each with 3 or 4 users) accessing the data file,
and each has its own front end mde on the server. The mde's open exclusively.
When a user at site 'A' prints a report or opens a form, it is called using something like:
DoCmd.Openrepor t rptname, , , "PropNum = " & gblPropNum
Where the PropNum is a unique ID (byte) for the property for which
that site has access, and gblPropNum is a global variable (byte) which is set
once for each site when the app is opened.
An intermittent problem (twice in 3 months) is occurring where data
from a second site finds its way into a report or a form for the first site.
Is it possible that the global variable could be the cause?
Has anyone else seen anything similar?
--
Bob Darlington
Brisbane
"Bob Darlington" <bo*@dpcmanAX.c om.au> wrote in message news:<40******* *************** *@news.optusnet .com.au>... Rick and James,
Thanks for the input.
As you say, as long as all procedures have error handlers, there shouldn't
be a problem with globals.
Let me clarify. The run-time error that you don't see because it's
caught by the error handler causes problems with global variables --
sometimes.
But I guess my question should be:
"Does anything change when used within a TS session?"
I don't know if anything changes within a TS session. My guess is
that the problem will happen just as often because the changes that TS
brings is largely moving more of the responsibility to the server side
rather than waving a magic wand that heals Access' problems.
James A. Fortune This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sara_S |
last post by:
I am ready to move my ASP web site onto a remote host. The
problem is that when I use Terminal Services to see the
host machine, the error does not show up.
(I was told that debugging info is only sent to
the 'console' session, no others). And the whole thing
locks up when there is a server error. How can I see the
server errors through...
|
by: Josh Schmidt |
last post by:
How can one set the terminal services profile and home
directory path in AD using VB.NET? I can set the usual
profile paths, but terminal services properties are not
supported with ADSI.
Any help is greatly appreciated!
Josh
|
by: DFS |
last post by:
An application I wrote has been deployed on Citrix, and the Citrix admin
tells me all users run the same .mde file. There aren't a lot of concurrent
users, but even 2 could be cause for concern.
I think the use of globals is worrisome in this case. Anybody have any
experience with Access on Citrix?
(Al Kallal already griped me out about...
|
by: TPoise! |
last post by:
Using: .NET 1.1, Visual Studio 2003, C#, Microsoft Windows 2000
Server (SP4 and all latest windows updates), Terminal Server running
in application mode.
I have a C# application that I've deployed to our terminal server for
remote users to use. However, normal users (simple domain users) can
not run the application. After double...
|
by: Brian Young |
last post by:
My department is responsible for creating custom internal applications for
many of our departments. Our strategy has always been to develop our
applications as ActiveX controls (VB6) that get hosted in Internet Explorer.
I've been tasked with coming up with a strategy for our migration to using
VB.Net. So far, I've experienced a number of...
| | |
by: OHM |
last post by:
Hi peoples,
I dont know where to place this question, so as I know you guys are all
resourceful experts, I thought I would try here.
I am writing some code which will be run usingh remote desktop ( On windows
2003 Server ), I need to determine in the code the machine name and
username. If I use GetUsername and GetMachineName, it simply...
|
by: Vinu |
last post by:
Hi,
I am facing one problem related to global variables in .so file. When
ever I access the variable the application is crashing
I have a class called services.
class services
{
services(){ }
void Add() { }
void Delete(){ }
|
by: shawn |
last post by:
In the past I have had SQL and Terminal server on the same PC.
With SQL and Windows 2003 Terminal server, you can not have them on the
same PC.
How can I make this work with SQL and Terminal and 2 different PC's? I
have 30 users that need to log on to my SQL database.
|
by: Gary Herron |
last post by:
Jacob Davis wrote:
Yuck, YUCK, YUCK! You are breaking *so* many
good-programming-practices, I hardly know where to start.
First off: A python global is not what you think. There are *no*
program wide globals. There are only module wide globals. Also, the
"global isglobal" is absolutely meaningless as anything declared there
is a...
|
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...
|
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...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
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...
|
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...
|
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.
| |
