Access Compact Error 1017
Contents |
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get microsoft access error code 1017 Help Ask a Question Ask for Help Receive Real-Time
Ms Access Error Code 1017
Help Create a Freelance Project Hire for a Full Time Job Ways to Get error 1017 project 1999 Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange
Error 1017 Everquest
> Questions > Access 2000 Compact error - Error code is -1017 Want to Advertise Here? Solved Access 2000 Compact error - Error code is -1017 Posted on 2006-03-30 MS Access 1 Verified Solution 3 Comments 958 Views Last Modified: 2008-02-01 After compacting a corrupt Access 2K error 1017 received logging on to the standby ora 16191 DB, I now have the table MSysCompactError, which contains ErroCode -1017, and ErrorDescription, "Could not find field 'Description'". Anyone know what this means? Note: This DB does have linked tables, and did before compact aswell, if that makes a difference. 0 Question by:wbstech Facebook Twitter LinkedIn Google LVL 54 Best Solution bynico5038 I would try the Access decompile: http://www.granite.ab.ca/access/decompile.htm And/or Repair A97/A2000: http://support.microsoft.com/support/kb/articles/Q109/9/53.asp Jetcomp: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956 Go to Solution 3 Comments LVL 4 Overall: Level 4 Message Author Comment by:wbstech2006-03-30 Additional info: The table in question, according to MSysCompactError, is called 'StudentStatus'. Neither the original or the compacted version of this table have a field by the name of 'Description'. 0 LVL 54 Overall: Level 54 MS Access 53 Message Accepted Solution by:nico50382006-03-30 I would try the Access decompile: http://www.granite.ab.ca/access/decompile.htm And/or Repair A97/A2000: http://support.microsoft.com/support/kb/articles/Q109/9/53.asp Jetcomp: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956 First how
and get tips & solutions from a community of 418,417 IT Pros
Error 1017 (hy000) Can't Find File (errno 2)
& Developers. It's quick & easy. MSysCompactError P: n/a Kit
Error 1017 Archeage
Truong After compacting my database, I have the following in MSysCompactError ErrorCode, ErrorDescription, ErrorRecid, ErrorTable -1605,Could error 1017 received logging on to the standby 11g not find field 'Description'., ,tblFundClient -1017,Could not find field 'Description'.,?O,UNDERITE -1613,You cannot add or change a record becuase a related record is required in table 'CLIENT'., https://www.experts-exchange.com/questions/21794864/Access-2000-Compact-error-Error-code-is-1017.html , UNDERITE Can anyone help me make sense of this? There is no field named 'Description' in either tblFundClient or UNDERITE. I guess the next thing I'll try is remove any unrelated records in UNDERITE that corrospond to CLIENT. Can anyone help me with this too. CLIENT is the main table. I https://bytes.com/topic/access/answers/191419-msyscompacterror want to remove any records in UNDERITE that is not in CLIENT. How would I go abouts making this delete query. Thanks. Nov 12 '05 #1 Post Reply Share this Question 1 Reply P: n/a Tony Toews "Kit Truong"
Office 2010 / 2007 / 2003 Microsoft Access Compact/Repair error Ask a Question Sign up for Free 134 Experts currently online. Ask Questions for Free! Compact/Repair error - Microsoft Access I ran the compact/repair tool on http://www.textndata.com/forums/compact-repair-error-127598.html my database and now have a "MsysCompactError" table. I open it up and it says: error code error description ErrorTable -1017 could not find field 'description" MSysObjets -1611 could not find field 'description' MSysObjects anyone have http://www.utteraccess.com/forum/lofiversion/index.php/t583541.html an idea what thsi means?? thanks Sasha... Results 1 to 3 of 3 LinkBack LinkBack URL About LinkBacks Bookmark & Share Add Thread to del.icio.usTweet this thread Thread Tools Show Printable Version Email this Page… Subscribe to error 1017 this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-07, 02:07 PM #1 Compact/Repair error I ran the compact/repair tool on my database and now have a "MsysCompactError" table. I open it up and it says: error code error description ErrorTable -1017 could not find field 'description" MSysObjets -1611 could not find field 'description' MSysObjects anyone have an idea what thsi means?? thanks Sasha Sasha access error code Reply With Quote 08-07, 02:44 PM #2 Re: Compact/Repair error Sound very much like corruptions. I think Tony Toews has some info on this at: http://www.granite.ab.ca/access/corruptmdbs.htm -- HTH Van T. Dinh MVP (Access) "Sasha Furr"
parent/child relationship lost on a subform (or underlying one to many record - record 'lost' in many table).In attempting to correct access through up a 'not recognizable format' error when trying to open offending table.Tried compact and repair on back end - when opening access informs me that database is not recognizable format and requires repairing - when I hit 'repair' it tells me password (which is definitely correct) is not recognized.Have gone to latest back up available and this opens ok - did compact and repair (which worked ok although took a long time) - all appears ok but access has included a new table - MSysCompactError - with four fields and one record as below:-ErrorCode - "-1017"ErrorDescription - "Could not find field 'Description'"ErrorRecid - two boxes (looks like when you open an excel file in word)ErrorTable - ApplicationDetailsThis table is the one that caused the probs originally.Please help me to correct - all users are currently out of database and are 'twiddling thumbs' until fixed.I hope someone can help......Thanks! JayNoelOlimpo Nov 22 2004, 06:36 AM Suggestion:Take a new mdb and Import all Tables from the Corrupted database ...Then do the repair and Compact ... spennyc Nov 22 2004, 06:41 AM Hi Thanks for post...Will this keep the relationships or do I have to reconstruct them all again.Cheers! JayNoelOlimpo Nov 22 2004, 06:47 AM It will keep ....lso when you import click on the Options and Check menus and Toolbars to include your customized menus and toolbars ... spennyc Nov 22 2004, 07:08 AM HiWhen I try to import it comes up with the same message:-The database "databasename.mdb" needs to be repaired or isn't a database file.You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open.Do you want Microsoft Access to attempt to repair the database?Yes/NoIf I click Yes, it says 'Not a valid password' with just an ok box - when I click ok it says ' the database...... cannot be repaired or isn't a database file.Any ideas??? kuifjexx Nov 22 2004, 08:20 AM Did you used security?Maybe this can help=> How to troubleshoot and to repair a damaged Access 2002 or later database => Corrupt Microsoft Access MDBs FAQ Greetz from Belgium Luc aka Kuifjexx spennyc Nov 22 2004, 08:26 AM Thanks, Lucill take a look at -