Error Number 2147352567
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 14 Oct 2016 08:07:11 GMT by s_ac15 (squid/3.5.20)
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 company Business Learn more about 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 ms access run-time error -2147352567 (80020009) the data has been http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother/run-time-error-2147352567-the-value-you-entered/e676d41b-5ffb-49ad-8b65-5571f5dd17dc changed up vote 1 down vote favorite Been getting the above error all of a sudden in an Access DB I'm building. It triggers in a proc that I haven't edited in a while. Was working fine. The strange thing is, when the error triggers and I go into debug mode, I can immediately continue running the code and it works. I tried putting a pause in before http://stackoverflow.com/questions/13980663/ms-access-run-time-error-2147352567-80020009-the-data-has-been-changed that line runs, but it didn't seem to help. Here's a segment of the code, however, this proc generally just calls other procs: Call common.CalculateAllLoadTotals(Me, Me.AffiliateID, Me.ClientID, Me.FacilityID, Me.ProposalRevision) ' Call common_2.sSleep(2000) Me.chkProposalRevisionTreated = -1 Me.txtTreated.Requery The error highlights the following line: Me.chkProposalRevisionTreated = -1 Any thoughts? Scotty ms-access access-vba ms-access-2010 share|improve this question asked Dec 20 '12 at 21:22 MultiGuy 3211726 I'm not sure what a ghost break point is. You can have break points that you can't see? Anyway, I'm actually receiving an error (see subject) –MultiGuy Dec 20 '12 at 21:31 Tried that and also a Compact & Repair. Didn't fix the issue. –MultiGuy Dec 20 '12 at 21:35 I had this problem when Access tries to save data to a linked table (gotten from sql) which it cannot write to directly. –bgmCoder Jun 2 '15 at 23:44 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Well, I "solved" my issue with a different approach. No big deal really, but I used an SQL UPDATE query to change the value. It's very strange. Anyway, I'd still welcome anyone's insight into this issue. Scotty share|improve this answer answered
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 https://www.experts-exchange.com/questions/26912290/How-to-solve-runtime-error-'2147352567-80020009-'.html 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 > How http://www.tek-tips.com/viewthread.cfm?qid=51336 to solve runtime error '2147352567(80020009)' Want to Advertise Here? Solved How to solve runtime error '2147352567(80020009)' Posted on 2011-03-25 MS Access MS Development-Other 1 Verified Solution 11 Comments 1,998 Views Last Modified: 2013-11-27 error number I get this error when I try to change a control on a form and the control is a primary key in the underlying table. 0 Question by:SowleMan Facebook Twitter LinkedIn Google Best Solution bySowleMan DatabaseMX - If I cannot change a field that is a Primary Key, then the solution is to delete the child row and then re-add a replacement child row with error number 2147352567 new info (allowing ACCES to provide a new PK) Go to Solution 11 Comments LVL 75 Overall: Level 75 MS Access 75 MS Development-Other 13 Message Active 1 day ago Expert Comment by:DatabaseMX (Joe Anderson - Access MVP)2011-03-25 If the PK is an Access AutoNumber (?), then it cannot be changed. mx 0 Message Author Comment by:SowleMan2011-03-25 Thanks, DatabaseMX. I really don't want to change the key. I want to replace the key with another, valid PK. For example, I want to modify a transaction record so it points to The Home Depot, instead of Lowes. Sowleman 0 LVL 74 Overall: Level 74 MS Access 72 MS Development-Other 14 Message Expert Comment by:Jeffrey Coachman2011-03-26 Then something seems awry in your design... For example: If you are a shipper and you want to change the ship destination from Home Depot, to Lowes. The you have a "Stores" table: tblStores StoreID (Primary Key) StoreName ...ect ..Then you have a shipments table tblShipments ShipmentID (Primary Key) StoreID (Foreign Key) ShipmentDate ...etc These two tables are linked in the relationships window on "StoreID", and Referential Integrity is enforced. In this case, it is quite easy
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: ASP (Active Server Pages) Forum at Tek-Tips HomeForumsProgrammersWeb DevelopmentMicrosoft: ASP (Active Server Pages) Forum Undefined Error -2147352567 thread333-51336 Forum Search FAQs Links MVPs Undefined Error -2147352567 Undefined Error -2147352567 mbert (TechnicalUser) (OP) 31 Jan 01 13:57 I'm receiving an undefined error (ERR NO: -2147352567) consistantly in a specific page. I've looked, without success, for a description of this error. One exception to when the error occurs should be noted... In our Intranet mirror site (of our internet site), calling an exact duplicate page, the error does NOT occur. It only occurs in the internet site.Here is a typical error message received via CDONTSMail:DATE: 1/10/01 11:40:26 AMERR NO: -2147352567DESCRIPTION:SCRIPT: /claims/claimant_info_pc.asp?CN=000000036981&CS=0001&ADJ=70The site is for an insurance company. The page in question lists Claim information including a link to specific claimant(s). It's in activating that link when the