LinkBack Thread Tools Display Modes #1 02-12-2016, 05:50 AM ktest Windows 8 Office 2007 Novice Join Date: Feb 2016 Posts: 1 Reserved error(-1517); there is no message for I did use thecompact/repair to do it and that worked fine. Everything would work fine for days or weeks until the backend was compacted. I should also note that I ran the "compact and repair database" tool and I am still getting the same error message. this content
Nov 20 '09 #2 reply Expert 100+ P: 234 topher23 Curiouser and curiouser. The combo box, which is based on the table on which I was inserting fields,was missing data in most of the columns.. In addition this particular app has an opening form where users decide the job they want. Check your references to see if any show as "Missing" Ctrl+G, Tools -References Otherwise, I'm stumped. http://www.access-programmers.co.uk/forums/showthread.php?t=105035
If you change the design of the backend, compact it, compact f/e and then re-link. Does this mean that the database is corrupt and could this problem be linked to that? The Where Condition for the filter is: Right([tblContracts].[JobNum],4)=Right([Forms]![FrmContProc].[txtFindJobNum],4) The weird thing is that it only occurs if the Form window is taller than 1/2 of my viewable area.
In looking directly into the database and linked databases, all of the columns and rows look clean all the way to the last record. The transient nature of the effect and your observation of window sizing as a factor suggests that it might be memory related. Then I tried to use the JET utility on the front end but it just kept saying 'Error Compacting database' straight away. Reserved Error (-7778) The fact that you cannot change existing customers suggests that the problem may be there.
Everything would work fine for days or weeks until the backend was compacted. Reserved Error There Is No Message For This Error So, I re-built the code to use a recordset instead of the RunSQL function. When I had decompiled it, I compacted it using the compact/repair in Access. https://bytes.com/topic/access/answers/755132-reserved-error-1524-there-no-message-error Reserved error (-1517) - Microsoft Access Hi, For years we have been running a large Access program that has the forms in one mdb file and the tables in another mdb
Any thoughts? Reserved Error Ms Access Any idea what could have caused this? Thanks! If I see it come up again, I'll try re-linking the tables, as Chip mentioned.
You can probably avoid compacting by deleting and recreating table links in many cases; this will clear cached info, obviously (since it is cached in the link). [ Access Tips | The reserved error simply means you have a missing reference of a more obscure type - a message-definition module somewhere. 2. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. http://supercgis.com/reserved-error/reserved-error-1517.html Any thoughts?
CDO.Message.1 error 80070005 Browse more Microsoft Access / VBA Questions on Bytes Question stats viewed: 9332 replies: 8 date asked: Jan 3 '08 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" Microsoft Access Reserved Error Fred Jan 3 '08 #6 P: n/a Fred Zuckerman "Fred Zuckerman" <[email protected] in message news:[email protected] t... "adampierce"
I guess it helps that there's no danger of any updates going through at the point of cut-off though. I realise now that editing the code while it was in break mode may have caused problems. Jan 3 '08 #3 P: n/a Fred Zuckerman "adampierce" They could easily take 100Kb to 1 Mb for each occurance on a form. I changed code as well to make sure that that I set objects to nothing. Thanks Tom Tom Reply With Quote 11-24, 08:17 PM #8 Re: Reserved Error (-1517) "Tom Ross"
They could easily take 100Kb to 1 Mb for each occurance on a form. I changed code as well to make sure that that I set objects to nothing. Thanks Tom Tom Reply With Quote 11-24, 08:17 PM #8 Re: Reserved Error (-1517) "Tom Ross"