Error Code 3211
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 10 Oct 2016 20:07:10 GMT by s_wx1094 (squid/3.5.20)
Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rate Thread Display Modes 08-01-2005, 12:16 PM #1 Pan Registered User Join Date: Mar 2004 Posts: 21 Thanks: 0 Thanked 0 Times in 0 Posts Table lock - Run-time error 3211 ???? I have a form with a combo box that contains a list of customers. Select a customer from the combo box and the form fields populate with general customer info. The form has a subform on it with a combo box where you can select products. Select a product from the combo box and the http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/error-3211-table-in-use/a115e45a-2cd1-46c1-b0ff-67a9081f5d0b subform populates with customer-specific product info. If I open the main form and select a customer, then without doing anything else I select another customer, everything works ok. It’s when I select a product on the subform, and then try to select a different customer on the main form that I get “Run-time error 3211: The database engine could not lock table tblCustomer because it is in use by another person or process.” Can anybody shed some light on this? http://www.access-programmers.co.uk/forums/showthread.php?t=91173 I’ve been confounded by it for days. Pan View Public Profile Find More Posts by Pan 08-02-2005, 08:33 AM #2 quest4 Registered User Join Date: Oct 2004 Posts: 246 Thanks: 0 Thanked 0 Times in 0 Posts What is, very simply put, happening is you opened one record, via the Customer selection and you have not save it and closed it and then you are trying to open another. Is that kind of clear to you? A simple cure is to add a cmdButton to the form, cal it Save and then add a second cmdButton and call it New or Add. Use the wizard to build these and they should be close to what you need. As you get better at this there are some real cute ways to improve this, but I don't know how good you are at code. hth. quest4 View Public Profile Find More Posts by quest4 08-02-2005, 09:55 AM #3 Pan Registered User Join Date: Mar 2004 Posts: 21 Thanks: 0 Thanked 0 Times in 0 Posts I'm very thankful to you for replying. However, I knew I ran the risk of miscommunicating by way oversimplifying the issue. I can edit the current record on the main form as much as I want and still successfully select a different customer from the customer combo box with
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 https://www.experts-exchange.com/questions/23606755/Runtime-error-3211-using-Access-VBA.html 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 http://cs.pervasive.com/forums/t/9344.aspx Website Testing Store Headlines Experts Exchange > Questions > Runtime error 3211 using Access VBA Want to Advertise Here? Solved Runtime error 3211 using Access VBA Posted on 2008-07-30 database engine MS Access 1 Verified Solution 7 Comments 3,445 Views Last Modified: 2013-11-27 Hi experts, I encountered the run-time error 3211: The databse engine couldn't lock 'TempTable' because it is in use by another person or process. Currently, I built in the function in MS Access using VBA such that each time I click on "Update" button, a table "TempTable" database engine could will be imported from Excel. Then information I need will be picked up from "TempTable" and copied to other tables that I have. After this, the "TempTable" will be deleted after the command: CurrentDb.Execute "DROP TABLE TempTable" This run-time error happens each time when I try to click on "Update" for the second time. If I close the program, restart it and click on "Update", it works fine. Can anyone help me explain the error? Any solutions on this? Thanks! 0 Question by:angie_angie Facebook Twitter LinkedIn Google LVL 16 Best Solution byRick_Rickards It's probably inside the code that's tapping the TempTable. Any Open Recordsets that may still be attached to it? Might help to see the code you're using when you Click Update. Go to Solution 7 Comments LVL 16 Overall: Level 16 MS Access 15 Message Accepted Solution by:Rick_Rickards2008-07-30 It's probably inside the code that's tapping the TempTable. Any Open Recordsets that may still be attached to it? Might help to see the code you're using when you Click Update. 0 LV
by krh104. 2 replies. Page 1 of 1 (3 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 05-28-2000 10:13 AM JohnRitchie Joined on 04-23-2008 Posts 3 Error code 3211 Reply Contact Hi, One of my customers received an error 3211 on a Btrieve update function. I have searched the docs on my system as well as downloaded the latest .hlp files from Pervasive site but I still can't find an error 3211 listed . Any ideas? 07-10-2000 3:05 AM In reply to Davin Joined on 04-23-2008 Posts 154 Re: Error code 3211 Reply Contact I don't see anything in my books either. You might want to check and make sure that it's really coming from PSQL and not from elsewhere in the application (such as Winsock or other MS-based systems) and just masquerading as a database code. 07-14-2000 10:03 PM In reply to krh104 Joined on 04-23-2008 Posts 15 Re: Error code 3211 Reply Contact This series of errors is usally about connectivity. Also ensure the engine has enough sessions Server | Configuration | Sessions. Installing licenses does not seem to adjust this Default is 10 or 15. Number 16 to attempt access gets an error in this series. Nothing tells you to adjust this number.Just a thought Page 1 of 1 (3 items) 800.287.4383 | Privacy Policy | Terms & Conditions © 2013 Actian Corporation. All Rights Reserved.