R
Ragnar Midtskogen
Hello,
I have a client who is still using an Access 97 DB application and it has
been giving me the fits recently.
They are thinking about upgrading to 2003, but it will take some time.
It is a very old application originally written in Access 2 by someone else,
so it has tons of macro's
I have made some updates and tested them on my machines, where everything
works correctly.
At my client's office however there is a problem, mostly with a report. In
the report's Detail Format event proc
several controls are populated with mailing and billing info by copying data
from hidden controls based on
the report's RecordSource query.
When producing this report they get an error that says that this report has
no data. I put up that message
in the NoData event proc, to make it clearer what the problem is. Without
the NoData proc the message
is: "You referred to a control or object which has no value" which is not
very informative.
When there is a problem these controls on the report are empty, but the
controls which are based on the
report's RecordSource query has data, so there seems to be a timing problem?
The client insists on keeping the app and the back end file on a network
drive and opening it from their
individual machines.
For testing purposes I have duplicated this setup here. I am running several
machines on a 100 Mb Microsoft network
by using a router, and I have tried several combinations of client/server
and have not found any problems.
The client is also running a Microsoft network, the network is 1 Gb and all
the workstations have 100 Mb NIC's.
Has anyone seen this problem?
Any help with this will be appreciated.
Ragnar
I have a client who is still using an Access 97 DB application and it has
been giving me the fits recently.
They are thinking about upgrading to 2003, but it will take some time.
It is a very old application originally written in Access 2 by someone else,
so it has tons of macro's
I have made some updates and tested them on my machines, where everything
works correctly.
At my client's office however there is a problem, mostly with a report. In
the report's Detail Format event proc
several controls are populated with mailing and billing info by copying data
from hidden controls based on
the report's RecordSource query.
When producing this report they get an error that says that this report has
no data. I put up that message
in the NoData event proc, to make it clearer what the problem is. Without
the NoData proc the message
is: "You referred to a control or object which has no value" which is not
very informative.
When there is a problem these controls on the report are empty, but the
controls which are based on the
report's RecordSource query has data, so there seems to be a timing problem?
The client insists on keeping the app and the back end file on a network
drive and opening it from their
individual machines.
For testing purposes I have duplicated this setup here. I am running several
machines on a 100 Mb Microsoft network
by using a router, and I have tried several combinations of client/server
and have not found any problems.
The client is also running a Microsoft network, the network is 1 Gb and all
the workstations have 100 Mb NIC's.
Has anyone seen this problem?
Any help with this will be appreciated.
Ragnar