Access 2007 Error 3761
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Access 2007 "the decimal field's precision is too small" Want to Advertise Here? Solved Access 2007 "the decimal field's precision is too small" Posted on 2011-01-03 MS Access Query Syntax Oracle Database 3 Verified Solutions 15 Comments 5,028 Views Last Modified: 2012-10-11 We are running a Make Table query that pulls from two Oracle tables. It has always run without error every month, but this month no luck. We receive this error in a pop-up window: ========= Microsoft Visual Basic Run-time error '3761': The decimal field's precision is too small to accept the numeric you attempted to add. [Continue] [End] [Debug] [Help] ========= That's the error we receive when it is running via the VBA that we usually run to execute everything in order. The following, simpler error comes up if running manually, just the single query: ========= Microsoft Office Access The decimal field's precision is too small to accept the numeric you attempted to add. [OK] [Help] ========= Any thoughts? Thanks! 0 Question by:jn1480 Facebook Twitter LinkedIn Google Best Solution byjn1480 Thanks for all the help guys - turned out to be an issue with the linked table. A DBA had changed the field size of one of the fields from 4 to six digits: ========= Field Size: Decimal ; Precision: Go to Solution 15 Comments LVL 92 Overall: Level 92 MS Access 50 Query Syntax 34 Oracle Database 4 Message Active today Expert Comment by:Patrick Matthews2011-01-03 Sounds like a data type problem. For example, if you have a column specified as decimal(7, 3), the moment you try to insert a value of 10,000 into that column you will get this error, because the data type is only allowing for 4 significant digits to the left of the decimal point. What are the data types of the columns involved, and what sort of operations are you using in your make-table query? 0 Message Author Comment by:jn14802011-
VBA Code & Other Help Access Help Solved: ORACLE ODBC Error precision too small 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. Results 1 to 8 of 8 Thread: Solved: ORACLE ODBC Error precision too small Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode https://www.experts-exchange.com/questions/26712838/Access-2007-the-decimal-field's-precision-is-too-small.html Switch to Threaded Mode 10-10-2008,01:25 AM #1 kunguito View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Jun 2007 Posts 67 Location Solved: ORACLE ODBC Error precision too small Hi, I connected to an ORACLE DATABASE using an ODBC from Access. Most tables work as requested but there's one that when opened promts this error message. The decimal http://www.vbaexpress.com/forum/showthread.php?22762-Solved-ORACLE-ODBC-Error-precision-too-small field's precision is too small to accept the numeric you attempt to add. The table is full of #Error, #Error, ... Any idea of what's happening? Maybe Access version? David Delcor Reply With Quote 10-15-2008,12:11 AM #2 Oorang View Profile View Forum Posts View Blog Entries Visit Homepage View Articles Knowledge Base Approver VBAX Master Joined Jan 2007 Posts 1,135 Location Hi David, "Precision" is just a fancy way of saying "number of decimals". Example: 3.14159265 has more precision than 3.14. All the error is saying is that you are trying to put a number with too many decimal places into a field that has a data-type that is too small to handle it. When you look at the data type of the field in Access, what type is it? What type is it in Oracle? Post back, we should be able to get you rolling (hopefully). Cordially, Aaron Keep Our Board Clean! Please Mark your thread "Solved" if you get an acceptable response (under thread tools).Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readabili
Jul 31, 2004. Olympia Chu Guest Does anyone know how to change the default setting in Access to receive data in numeric format with 4 decimal places prior to the http://www.office-forums.com/threads/error-3761-decimal-fields-precision-is-too-small.482681/ creation of a table? I'm trying to import a table from an external database that includes data up to 4 decimal places. However, Access is generating this import error because the default setting in Access only allows data up to 2 decimal places. Regards, Olympia Olympia Chu, Jul 31, 2004 #1 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? It takes access 2007 just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum. Sign Up Now! Similar Threads Access / DAo Error 3761 Aimo, Oct 7, 2003, in forum: Access External Data Replies: 0 Views: 180 Aimo Oct 7, 2003 "The Decimal field's precision is too small to accept the numeric you access 2007 error attempted , Jan 13, 2004, in forum: Access External Data Replies: 0 Views: 349 Jan 13, 2004 "The Decimal field's precision is too small to accept the numeric you attempted to add" TONECHO, Jan 14, 2004, in forum: Access External Data Replies: 1 Views: 296 Jan 14, 2004 Decimal field precision error in linked table priya, Apr 8, 2004, in forum: Access External Data Replies: 0 Views: 145 priya Apr 8, 2004 Access, Error 3761 Juan Gonzalez, Dec 23, 2004, in forum: Access External Data Replies: 0 Views: 221 Juan Gonzalez Dec 23, 2004 Decimal precision limited to only 2 places? Bigfoot, Jan 29, 2005, in forum: Access External Data Replies: 6 Views: 89 Ken Snell [MVP] Jan 30, 2005 Import table error decimal field precision too small Kosei B, Jun 26, 2006, in forum: Access External Data Replies: 0 Views: 222 Kosei B Jun 26, 2006 Access 97: "Field is too small" error on upsized ODBC data set Stu W, Oct 2, 2007, in forum: Access External Data Replies: 4 Views: 168 Sylvain Lafontaine Oct 3, 2007 Loading... Your name or email address: Do you already have an account? No, create an account now. Yes, my password is: Forgot your password? Stay logged in