Error Number 3163
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
only with mde on production server + Ask a Question Need help? Post your question and get tips & solutions from a community of 418,536 IT Pros & Developers. It's quick & easy. stumped - 'field too small to accept....' (err number 3163) error only with MDE on production server P: n/a astro Anyone have suggestions on where to troubleshoot this error? Background: -Access 2k v. 9.0.6926 sp3 - front and backend on production server (wiindows 2k) -accessed via Citrix -front-end is mde, backend is mdb -only occurs on the production server -only occurs with mde verson - i've tested the problem with the mdb version of the front-end and https://support.microsoft.com/en-us/kb/966165 it loads/generates the document fine on the production server -i've zipped and loaded the app on my work PC and the mde version loads/generates the document fine Feedback greatly appreciated. Thanks. Nov 13 '05 #1 Post Reply Share this Question 7 Replies P: n/a Salad astro wrote: Anyone have suggestions on where to troubleshoot this error? Background: -Access 2k v. 9.0.6926 sp3 - front and backend on production server (wiindows 2k) -accessed via Citrix -front-end is https://bytes.com/topic/access/answers/209753-stumped-field-too-small-accept-err-number-3163-error-only-mde-production-server mde, backend is mdb -only occurs on the production server -only occurs with mde verson - i've tested the problem with the mdb version of the front-end and it loads/generates the document fine on the production server -i've zipped and loaded the app on my work PC and the mde version loads/generates the document fine Feedback greatly appreciated. Thanks. Do you have any idea which field is attempted to be filled? If so, compare its type and size in the table. Look for Table Specification in help. Are you attempting to stuff a memo with more than 65,535 characters? Are you attempting to stuff a text field with more than 255 characters? Nov 13 '05 #2 P: n/a David W. Fenton "astro"
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site http://stackoverflow.com/questions/18991635/getting-an-error-3163-on-ms-access-2003 About Us Learn more about Stack Overflow the company Business Learn more about http://www.tek-tips.com/viewthread.cfm?qid=572469 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Getting an error error number (3163) on MS Access 2003 up vote 1 down vote favorite The error says "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." The database is supposed to pull in information from the Excel sheet that is passed through to it, and import the information into a recordset of the text field. However, error number 3163 the text field, somewhere down the line, has been limited to 50 characters. How can I change the maximum size of the text field? Thank you for any help This is just part of the code, and the textfield I'm trying to make larger is "Idea_#", which is the last line of the code i posted Sub Read_Recommendations() On Error GoTo error_code Dim FD As Office.FileDialog Dim xlapp As Excel.Application Dim xlsheet As Excel.Worksheet Dim xlbook As Excel.Workbook Dim db As Database Dim rs As Recordset Dim sql As String Dim WP As String Dim row As Integer Dim File As String Set db = CurrentDb Set FD = Application.FileDialog(msoFileDialogOpen) If FD.Show = True Then File = FD.SelectedItems(1) Set xlapp = CreateObject("Excel.Application") Set xlbook = GetObject(File) Set xlsheet = xlbook.Worksheets("Recommendation Approval Form") Dim protection As Boolean With xlsheet 'support unprotected worksheets protection = xlsheet.ProtectContents If protection Then xlsheet.Unprotect "veproject" WP = .Range("WP_Number") ' Check that active WP and the WP of the uploading form is the same ' If WPs are different, awares users and prompts user whether or not to continue Dim DifferentProject As String If Not get_WP = WP Then DifferentPr
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Modules (VBA Coding) Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Modules (VBA Coding) Forum Error 3163, But Size Isn't an Issue thread705-572469 Forum Search FAQs Links MVPs Error 3163, But Size Isn't an Issue Error 3163, But Size Isn't an Issue JeremyNYC (Programmer) (OP) 10 Jun 03 15:31 I've got a database that's been in production for two years. This issue has never come up before. I have made no changes to any code or tables affected by any of this.In code I have the following:strSql = "INSERT INTO TblMemoRecipient (ActionID, " _ & "EmployeeID, DiscrepancyID, CC, MemoCycle) " _& "VALUES (" & lngActionID & ", " & rst2!EmployeeID & ", " & lngDiscrepancyID & ", " & rst2!CC _& ", " & intMemoCycle & ")"debug.print strSqlCall db.Execute(strSql, dbFailOnError)The results of the debug are this:INSERT INTO TblMemoRecipient (ActionID, EmployeeID, DiscrepancyID, CC, MemoCycle) VALUES (93301, 2, 44561, False, 1)The execute give me this error:Error 3163: The field is too small to accept the amount of data you attempted to add.Try inserting or pasting less data.Here's a description of tblMemoRecipient:FieldNameTypeSizeActionIDLong Integer4EmployeeIDLong Integer4DiscrepancyIDLong Integer4CCYes/No1MemoCycleLong Integer4If I copy the SQL into the SQL view of a new query, I get the same error.If I creat