Grabbing strange number from a linked table Access XP

[ridgelon]

Hey there,

Hope someone can help me with this one, first off, our Access XP program
has a front end with forms and Fields that link up to tables on a back end on
a server. When someone puts in a selling price, the fees are populated from
the tables. We have several copies of our program out there and only one is
doing this: In no pattern that we can find, every once in a while when
someone puts in a selling price the fees come out with a number that is not
in our database.

Example: normally: Sell Price 10,000 Fees 175.00
on occasion Sell Price 10,000 Fees 85.13 or 79.68 or 58.00

The fees are always supposed to be what is put into the table: 175.00,
nothing changes, no reboot, no network connection failure, no closing of the
program and for some reason it puts in 58.00, close the program and reopen it
, enter a new deal and fees are correct. We have manualy relinked tables and
installed the latest update...Any ideas??

Any ideas???

 

[ridgelon]

Hey there,

Hope someone can help me with this one, first off, our Access XP program
has a front end with forms and Fields that link up to tables on a back end on
a server. When someone puts in a selling price, the fees are populated from
the tables. We have several copies of our program out there and only one is
doing this: In no pattern that we can find, every once in a while when
someone puts in a selling price the fees come out with a number that is not
in our database.

Example: normally: Sell Price 10,000 Fees 175.00
on occasion Sell Price 10,000 Fees 85.13 or 79.68 or 58.00

The fees are always supposed to be what is put into the table: 175.00,
nothing changes, no reboot, no network connection failure, no closing of the
program and for some reason it puts in 58.00, close the program and reopen it
, enter a new deal and fees are correct. We have manualy relinked tables and
installed the latest update and yes compacted and repaired both front and back ends.

Any ideas???

 

[ridgelon]

and we've compacted and repaired both back and front ends.

 

[John W. Vinson]

Hey there,

Hope someone can help me with this one, first off, our Access XP program
has a front end with forms and Fields that link up to tables on a back end on
a server. When someone puts in a selling price, the fees are populated from
the tables. We have several copies of our program out there and only one is
doing this: In no pattern that we can find, every once in a while when
someone puts in a selling price the fees come out with a number that is not
in our database.

Example: normally: Sell Price 10,000 Fees 175.00
on occasion Sell Price 10,000 Fees 85.13 or 79.68 or 58.00

The fees are always supposed to be what is put into the table: 175.00,
nothing changes, no reboot, no network connection failure, no closing of the
program and for some reason it puts in 58.00, close the program and reopen it
, enter a new deal and fees are correct. We have manualy relinked tables and
installed the latest update...Any ideas??

Any ideas???

Care to describe your table structure, and how the fee is stored and
presented? Are you using a Form, a table datasheet, a report, or what? If a
Form, what is the form's Recordsource?