[MS_AccessPros] Access display of Money from SQL Server in linked table

 

I have a friend who has a table on SQL Server with several "money" fields.  When displayed in a Datasheet in Access (via a linked table), the fields show either 0.00 or blank, even though the rows in SQL Server contain values.  He has tried updating one of the money fields (mapped to Currency in Access), and the update appears to go OK on the server, but the field goes blank after he saves the record.

 

Any ideas?

 

 

 

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1
• New Database 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___