Access 2007 and SQL Server Decimal Datatype

Access 2007 FE with SQL Server 2005 BE.
It has been recommended to me in a SQL Server newsgroup to use decimal
datatype instead of money for monetary fields due to rounding errors when
using money (currency).

I seem to remember something from a while ago about Access having some
problem with decimal datatypes, but can't remember details or find more
info.

Does anyone know of any problem with Access and decimal datatypes?

Thanks,

--

AG
Email: npATadhdataDOTcom

It works, but JET has problems sorting it:
http://allenbrowne.com/bug-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AG" wrote in message
...
Access 2007 FE with SQL Server 2005 BE.
It has been recommended to me in a SQL Server newsgroup to use decimal
datatype instead of money for monetary fields due to rounding errors when
using money (currency).

I seem to remember something from a while ago about Access having some
problem with decimal datatypes, but can't remember details or find more
info.

Does anyone know of any problem with Access and decimal datatypes?

Thanks,

--

AG
Email: npATadhdataDOTcom

Hi Customer,

This is Mark, a SQL Server engineer. I'm glad to assist you with the issue.

I agree with allen.

There is an article to share with you to introduce the feature of access
2007: http://www.allenbrowne.com/Access2007.html

If you have any questions when using access, welcome to post them here.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Thanks both. I think I will stick with the money/currency datatype.

--

AG
Email: npATadhdataDOTcom


"Allen Browne" wrote in message
...
It works, but JET has problems sorting it:
http://allenbrowne.com/bug-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AG" wrote in message
...
Access 2007 FE with SQL Server 2005 BE.
It has been recommended to me in a SQL Server newsgroup to use decimal
datatype instead of money for monetary fields due to rounding errors when
using money (currency).

I seem to remember something from a while ago about Access having some
problem with decimal datatypes, but can't remember details or find more
info.

Does anyone know of any problem with Access and decimal datatypes?

Thanks,

--

AG
Email: npATadhdataDOTcom

Hi AG,

Thank you for the update. I'm glad that my reply is helpful.

If anything I can assist you, please let me know.

Besides, if you have any questions on using money/currency datatype,
welcome to post it here.

Have a nice day.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======