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 printed 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 three
machines (Two Win XP Pro, one Win 2000) on a 100 Mb Microsoft network by
using a router, and I have tried several combinations of client/server
machines 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. All machines are running Win XP Pro.
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 printed 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 three
machines (Two Win XP Pro, one Win 2000) on a 100 Mb Microsoft network by
using a router, and I have tried several combinations of client/server
machines 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. All machines are running Win XP Pro.
Has anyone seen this problem?
Any help with this will be appreciated.
Ragnar