If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Access 2007 and SQL Server Decimal Datatype
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 |
#3
|
|||
|
|||
Access 2007 and SQL Server Decimal Datatype
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. ================================================== ======= |
#4
|
|||
|
|||
Access 2007 and SQL Server Decimal Datatype
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 |
#5
|
|||
|
|||
Access 2007 and SQL Server Decimal Datatype
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. ================================================== ======= |
Thread Tools | |
Display Modes | |
|
|