Error 3188 Ms Access
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 About Us Learn more about Stack Overflow the access could not update currently locked by another session on this machine company Business Learn more about hiring developers or posting ads with us Stack Overflow could not update currently locked by another session on this machine memo field Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 could not update currently locked access 2013 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to work around Access VBA error 3188 up vote 1 down vote favorite Having converted a number of fields in a table tblSource to Rich Text memos, I'm getting an error 3188 in the following circumstances. Main form has a subform open (frmSource) bound to qrySource. qrySource pulls in some fields from tblSource and adds a calculated field which concatenates the (newly-minted) rich-text memo fields (SD1 to SD20) so that the result can be displayed in a single text box on frmSource called Citation. If the user wishes to edit SD1 to SD20, they double-click on the Citation field and a modal form frmCitation opens up displaying the SD fields for editing. frmCitation is bound to qryCitation which pulls the SD fields and a couple of others out of tblSource. When finished, they close frmCitation. When SD1 etc were text fields, the tblSource record was updated successfully. However, now they're memo fields, I'm hitting VBA error 3188 ("Could not update; currently locked by another session on this machine."). Searching on the Internet suggests that this is a common issue with Rich Text memos when a memo size exceeds 2k (limitation possibly due to Access edit buffer size?), so I'm looking for ways to work around it. One option would be be to split tblSource into two tables tblSource and tblCItation with a one-to-one relationship between them, then base qrySource on tblSource and qryCitation on tblCitation, but that's fairly major surgery with knock-on effects in a number of other places in the application. Another option is to limit the size of all the memo fields on this form (as per Rich text input into limited length text field in Access 2010), but there's one field for which that wouldn't be acceptable to the users. Is there another technique I could explore? vba ms-access ms-access-2010 share|improve this question
be down. Please try the request again. Your cache administrator is webmaster. Generated Tue, 11 Oct 2016 08:57:15 GMT by s_ac15 (squid/3.5.20)
Custom Search UtterAccess Forums>Microsoft® Access>Access Forms Error 3188 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access http://www.utteraccess.com/forum/error-3188-t1789926.html TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu could not bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other could not update Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options NewFuturesView Member Profile Feb 24 2009, 09:16 PM Post#1Posts: 3Joined: 25-January 04From: NW FloridaCould not update; currently locked by another session on this machineI have been using this form for for the last 2 years - suddenly I star getting this error!It got to be with the data - I loaded a backup data file from Nov08 and all seems fineAny Ideas? Scott McDanielView Member Profile Feb 24 2009, 09:38 PM Post#2UtterAccess VIPPosts: 579Joined: 18-February 09From: North Augusta, SCWhat do you mean by "loaded a backup data file"? Do you mean you imported data into your da