Ms Access Error 3761
for 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,119 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-01-03 I am confused... (yes, a bit
DriverDoc WinSweeper SupersonicPC FileViewPro About Support Contact Errors Troubleshooting › Runtime Errors › Microsoft Corporation › Microsoft Access › Error 3761 How To Fix Microsoft Access Error 3761 Error Number: Error 3761 Error Name:Microsoft Access Error 3761 Error Description: The decimal field's precision is too small to accept the numeric you attempted to add. Developer:Microsoft Corporation Software:Microsoft Access Applies to:Windows XP, Vista, 7, 8 Download NowWinThruster 2015 - Scan your PC for computer errors. https://www.experts-exchange.com/questions/26712838/Access-2007-the-decimal-field's-precision-is-too-small.html Compatible with Windows 10, 8, 7, Vista, XP and 2000 Symptoms of Error 3761 "Error 3761" appears and crashes the active program window. Your PC frequently crashes with Error 3761 when running the same program. “Microsoft Access Error 3761” is displayed. Windows runs sluggishly and responds slowly to mouse or keyboard http://www.solvusoft.com/en/errors/runtime-errors/microsoft-corporation/microsoft-access/3761-microsoft-access-error-3761/ input. Your computer periodically “freezes” for a few seconds at a time. These 3761 error messages can appear during program installation, while a Microsoft Corporation-related software program (eg. Microsoft Access) is running, during Windows startup or shutdown, or even during the installation of the Windows operating system. Keeping track of when and where your 3761 error occurs is a critical piece of information in troubleshooting the problem. Causes of Error 3761 Corrupt download or incomplete installation of Microsoft Access software. Corruption in Windows registry from a recent Microsoft Access-related software change (install or uninstall). Virus or malware infection that has corrupted Windows system files or Microsoft Access-related program files. Another program maliciously or mistakenly deleted Microsoft Access-related files. Runtime Errors such as “Error 3761” can be caused by a variety of factors, so it is important that you troubleshoot each of the possible causes to prevent it from recurring. Runtime Erro
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 http://www.office-forums.com/threads/error-3761-decimal-fields-precision-is-too-small.482681/ to the 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 ms access own question? It takes 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: 186 Aimo Oct 7, 2003 "The Decimal field's precision is too ms access error small to accept the numeric you attempted , Jan 13, 2004, in forum: Access External Data Replies: 0 Views: 356 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: 302 Jan 14, 2004 Decimal field precision error in linked table priya, Apr 8, 2004, in forum: Access External Data Replies: 0 Views: 150 priya Apr 8, 2004 Access, Error 3761 Juan Gonzalez, Dec 23, 2004, in forum: Access External Data Replies: 0 Views: 227 Juan Gonzalez Dec 23, 2004 Decimal precision limited to only 2 places? Bigfoot, Jan 29, 2005, in forum: Access External Data Replies: 6 Views: 93 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: 223 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: 172 Sylvain Lafontaine Oct 3, 2007 Loading... Your name or email address: Do you already have an account? No, create an accoun