(Again) Disappearing / Reappearing Data - Access97
| Author |
Message |
|
Brad Simo
#1 / 6
|
 (Again) Disappearing / Reappearing Data - Access97 Help!
I have an access database application that I have sold to three customers.
It is running on almost identical systems (I built them). Windows 95, with
Office97 Professional installed. I have had a reoccurring problem with only
one customer, and we have narrowed it down to not being there fault, and not
being the application's fault (my fault).
Here is what it does:
After the database has been running for awhile (say at least 2 hours)
Information disappears. That is alarming. The interesting thing is,
sometimes if they go out of access all together, and just restart the
application, the information reappears. When this doesn't work, they shut
down the entire machine (properly, I am assuming), restart the machine, and
get back in to the application, it is all there again. They use it to track
their inventory, and to track their customers' payments. So today when they
printed out a receipt to a customer that said they owed over $1500 (initial
cost of item), when in fact they owed about $700. This made for a VERY
angry customer to them and them to me. It did have all of the payments in
there, it just didn't total it up (a simple sum function). It was like this
for all customers until they shut down the entire machine, and restarted.
Then everything was ok.
I have no idea why Access97 would do this. I did have System Agent running
in the background, but disabled it a few weeks ago. It seemed to have fixed
the problem, until today.
It seems that Access97 or Windows 95 is doing something in the background
that messes things up. (an assumption)
If anyone has any help at all, I NEED to hear it. Please respond to my
Thanks in advance for any assistance,
Brad Simon
www.symasytes.com
|
| Wed, 09 Aug 2000 03:00:00 GMT |
|
 |
|
Michael Kapla
#2 / 6
|
(Again) Disappearing / Reappearing Data - Access97 I'm curious how you can unilaterally determine that this is not an
application issue. If you are using a query to total the amounts in tables,
then not running the query against refreshed data (i.e. a snapshot or an
uncomitted transaction somewhere or simple delay of updates showing up in a
shared database), then you will see the same symptoms you describe.
Michael
Quote: >Help! >I have an access database application that I have sold to three customers.
>It is running on almost identical systems (I built them). Windows 95, with
>Office97 Professional installed. I have had a reoccurring problem with
only
>one customer, and we have narrowed it down to not being there fault, and
not
>being the application's fault (my fault).
>Here is what it does:
>After the database has been running for awhile (say at least 2 hours)
>Information disappears. That is alarming. The interesting thing is,
>sometimes if they go out of access all together, and just restart the
>application, the information reappears. When this doesn't work, they shut
>down the entire machine (properly, I am assuming), restart the machine, and
>get back in to the application, it is all there again. They use it to
track
>their inventory, and to track their customers' payments. So today when
they
>printed out a receipt to a customer that said they owed over $1500 (initial
>cost of item), when in fact they owed about $700. This made for a VERY
>angry customer to them and them to me. It did have all of the payments in
>there, it just didn't total it up (a simple sum function). It was like
this
>for all customers until they shut down the entire machine, and restarted.
>Then everything was ok.
>I have no idea why Access97 would do this. I did have System Agent running
>in the background, but disabled it a few weeks ago. It seemed to have
fixed
>the problem, until today.
>It seems that Access97 or Windows 95 is doing something in the background
>that messes things up. (an assumption)
>If anyone has any help at all, I NEED to hear it. Please respond to my
>Thanks in advance for any assistance,
>Brad Simon
>www.symasytes.com
|
| Wed, 09 Aug 2000 03:00:00 GMT |
|
|
|
Brad Simo
#3 / 6
|
(Again) Disappearing / Reappearing Data - Access97 I can make that statement simply because it works fine on the other 2
commercial places, and on my computer, and a test computer. I am only
having the problem on the one computer.
Quote:
>I'm curious how you can unilaterally determine that this is not an >application issue. If you are using a query to total the amounts in tables, >then not running the query against refreshed data (i.e. a snapshot or an >uncomitted transaction somewhere or simple delay of updates showing up in a >shared database), then you will see the same symptoms you describe. >Michael
>>Help!
>>I have an access database application that I have sold to three customers.
>>It is running on almost identical systems (I built them). Windows 95,
with
>>Office97 Professional installed. I have had a reoccurring problem with
>only
>>one customer, and we have narrowed it down to not being there fault, and
>not
>>being the application's fault (my fault).
>>Here is what it does:
>>After the database has been running for awhile (say at least 2 hours)
>>Information disappears. That is alarming. The interesting thing is,
>>sometimes if they go out of access all together, and just restart the
>>application, the information reappears. When this doesn't work, they shut
>>down the entire machine (properly, I am assuming), restart the machine,
and
>>get back in to the application, it is all there again. They use it to
>track
>>their inventory, and to track their customers' payments. So today when
>they
>>printed out a receipt to a customer that said they owed over $1500
(initial
>>cost of item), when in fact they owed about $700. This made for a VERY
>>angry customer to them and them to me. It did have all of the payments in
>>there, it just didn't total it up (a simple sum function). It was like
>this
>>for all customers until they shut down the entire machine, and restarted.
>>Then everything was ok.
>>I have no idea why Access97 would do this. I did have System Agent
running
>>in the background, but disabled it a few weeks ago. It seemed to have
>fixed
>>the problem, until today.
>>It seems that Access97 or Windows 95 is doing something in the background
>>that messes things up. (an assumption)
>>If anyone has any help at all, I NEED to hear it. Please respond to my
>>Thanks in advance for any assistance,
>>Brad Simon
>>www.symasytes.com
|
| Thu, 10 Aug 2000 03:00:00 GMT |
|
|
|
Jeff Lasm
#4 / 6
|
(Again) Disappearing / Reappearing Data - Access97
Quote: >I can make that statement simply because it works fine on the other 2
>commercial places, and on my computer, and a test computer. I am only
>having the problem on the one computer.
Mind you, I don't use Access enough to knock it, so I'm not. Just pointing out an interesting occurrence: The month before Christmas I was attempting to make sense out of a
homegrown piecework-payroll-tracking program written in Access97.
It was pretty simple. Each job code was entered on a per-employee
basis.
No mis-indexing concerns; each employees jobs were presorted and
entered together.
Then two reports were run; one would bill the proper agency for the
employee's work; one would pay the employee.
Both were simple reports; nothing more.
The customer always got billed properly. The employees didn't always
get paid properly; there was mis-billing in two of the job codes.
I never tracked it down; my job was to find the error in the payroll.
I did, and reported it. I've never heard from that client again.
Was it Access' fault? I have no idea.
Quote:
>>I'm curious how you can unilaterally determine that this is not an
>>application issue. If you are using a query to total the amounts in tables,
>>then not running the query against refreshed data (i.e. a snapshot or an
>>uncomitted transaction somewhere or simple delay of updates showing up in a
>>shared database), then you will see the same symptoms you describe.
--
Publisher, "Interesting Times" Computer Industry newsletter.
"subscribe InterestingTimes" (as shown, but without the quotes) in the BODY of your email. You'll be put on the list, and get a help file and a sample issue.
|
| Thu, 10 Aug 2000 03:00:00 GMT |
|
|
|
Paul Wrag
#5 / 6
|
(Again) Disappearing / Reappearing Data - Access97 Are you using transactions? Perhaps these are gettin getting out of synch?
(you start one but don't end it, so your transactions get nested)?
|
| Mon, 14 Aug 2000 03:00:00 GMT |
|
|
|
Michael Kapla
#6 / 6
|
(Again) Disappearing / Reappearing Data - Access97 Which means it can easily be an environment or timing issue that ha nothing
to do with Access at all. Like I said, it seems unlikely (especially if it
works fine in some places) that this has anything to do with Access itself
rather than an environmental or timing issue.
Michael
Quote: >I can make that statement simply because it works fine on the other 2 >commercial places, and on my computer, and a test computer. I am only >having the problem on the one computer.
>>I'm curious how you can unilaterally determine that this is not an
>>application issue. If you are using a query to total the amounts in
tables,
>>then not running the query against refreshed data (i.e. a snapshot or an
>>uncomitted transaction somewhere or simple delay of updates showing up in
a
>>shared database), then you will see the same symptoms you describe.
>>Michael
>>>Help!
>>>I have an access database application that I have sold to three
customers.
>>>It is running on almost identical systems (I built them). Windows 95,
>with
>>>Office97 Professional installed. I have had a reoccurring problem with
>>only
>>>one customer, and we have narrowed it down to not being there fault, and
>>not
>>>being the application's fault (my fault).
>>>Here is what it does:
>>>After the database has been running for awhile (say at least 2 hours)
>>>Information disappears. That is alarming. The interesting thing is,
>>>sometimes if they go out of access all together, and just restart the
>>>application, the information reappears. When this doesn't work, they
shut
>>>down the entire machine (properly, I am assuming), restart the machine,
>and
>>>get back in to the application, it is all there again. They use it to
>>track
>>>their inventory, and to track their customers' payments. So today when
>>they
>>>printed out a receipt to a customer that said they owed over $1500
>(initial
>>>cost of item), when in fact they owed about $700. This made for a VERY
>>>angry customer to them and them to me. It did have all of the payments
in
>>>there, it just didn't total it up (a simple sum function). It was like
>>this
>>>for all customers until they shut down the entire machine, and restarted.
>>>Then everything was ok.
>>>I have no idea why Access97 would do this. I did have System Agent
>running
>>>in the background, but disabled it a few weeks ago. It seemed to have
>>fixed
>>>the problem, until today.
>>>It seems that Access97 or Windows 95 is doing something in the background
>>>that messes things up. (an assumption)
>>>If anyone has any help at all, I NEED to hear it. Please respond to my
>>>Thanks in advance for any assistance,
>>>Brad Simon
>>>www.symasytes.com
|
| Sat, 19 Aug 2000 03:00:00 GMT |
|
| |
|
