Data does not show in the linked table

[Guest]

I have an access frontend application and the data is being stored on an sql
server. For one of the tables in the database (tblPricing), not all the data
is not showing up in the access frontend but is visible on the sql server. I
cant see what the problem is because all of the other tables which are linked
the same way do not have this problem also this does not cause problems on
all computers. The data that is not showing is the prices and the data type
on the sql server is money.

Please can someone help me....

 

[John Vinson]

I have an access frontend application and the data is being stored on an sql
server. For one of the tables in the database (tblPricing), not all the data
is not showing up in the access frontend but is visible on the sql server. I
cant see what the problem is because all of the other tables which are linked
the same way do not have this problem also this does not cause problems on
all computers. The data that is not showing is the prices and the data type
on the sql server is money.

Please can someone help me....

Is it some *RECORDS* not showing up? or some *FIELDS*?

Have you tried deleting the link in the Access table, and relinking
using File... Get External Data... Link? or just using Linked Table
Manager to relink?

Does compacting and repairing the frontend make any difference?

John W. Vinson[MVP]

 

[Guest]

It was some fields within the record that were not showing up but i have
fixed this problem. The data type of the fields in the sql server that were
not showing were set to money and for some reason access does not like this
data type so i changed it to numeric and set the format in access to
currency.

Thanks for the reply anyway

 

[xingxinglau]

It was some fields within the record that were not showing up but i have
fixed this problem. The data type of the fields in the sql server that were
not showing were set to money and for some reason access does not like this
data type so i changed it to numeric and set the format in access to
currency.

Thanks for the reply anyway