Bill Benson
bensonforums at gmail.com
Mon Jun 2 12:37:49 CDT 2014
Thanks Jim. I am fortunate to learn of this problem early. I have never had this happen in earlier versions (2010 on back to 97) and I don't think this bodes well for my love of 2013. I will probably put 2010 back and uninstall 2013. On Jun 2, 2014 8:00 AM, "Jim Dettman" <jimdettman at verizon.net> wrote: > > Unfortunately Microsoft never updated the JETCOMP.EXE tool for the .accdb > format. > > It was the only tool that would work (sometimes) in situations like this > because unlike the compact and repair, it would not open the DB as a DB > first, but treat it just like as a file and repair the DBH (Database > Header) > page first, then open the DB. > > If you can't open it, you don't have any options other than a recovery > service out on the net. > > Jim. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson > Sent: Sunday, June 01, 2014 10:22 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] corrupt database - backup rather out-dated. > > I cannot import anything because I get those error messages about id an not > a valid index, before I am even presented with the objects for import. > > I can open the database but I get that message several times, and I can > open > some tables (but not export them), but with every action I get that error > message many times. > > I cannot open any Forms in design view, nor Ctrl-G to see VBE. > > I can create a new form, but get the error message, and also get that error > message when adding any controls to a new form. > > Basically a hosed database. > > Dan Waters and Darryl Collins are giving it a look. Happy to send your way > too Doug. > > As I said there is no real data in it, it is quite small. > > Thanks. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele > Sent: Sunday, June 01, 2014 10:12 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] corrupt database - backup rather out-dated. > > Hi Bill: when you say you haven't been able to import 'anything' into a new > empty db, did you try importing one object type, eg tables, at a time, or > even one table at a time? Sometimes I've been able to recover most parts > of > a corrupt db very slowly piece by piece. > > Doug > > > On Sun, Jun 1, 2014 at 10:54 AM, Bill Benson <bensonforums at gmail.com> > wrote: > > > Hi Dan, I will send it on (my) Monday... thanks a lot. It is not a > > production db yet. > > > > Thanks again. > > On Jun 1, 2014 1:39 PM, "Dan Waters" <df.waters at outlook.com> wrote: > > > > > Hi Bill, > > > > > > I was the most recent person to create a program to help resolve > > > corrupt databases. There are undocumented functions named > > > SaveAsText and LoadFromText. SaveAsText will take all the non-table > > > objects and write them to text files. Then the reverse can be done > > > with LoadFromText. The idea is to get the definition of the objects > > > out of the 'corrupt' Access file, > > then > > > recreate these objects in a new database. > > > > > > If you can send me an off-line copy (w/o tables if possible) I'll > > > see > > what > > > I > > > can do. > > > > > > First, change the extension from .accdb to .pdf (this usually gets > > > around security checks). Then zip the file and email it to me. I > > > can probably get it back to you today or tomorrow morning at the > > > latest. > > > > > > If it's too large to email after being zipped, copy it to a blank > > > disk > > and > > > let me know and I'll give you my address. > > > > > > HTH, > > > Dan > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim > > > Lawrence > > > Sent: Sunday, June 01, 2014 11:49 AM > > > To: Access Developers discussion and problem solving > > > Subject: Re: [AccessD] corrupt database - backup rather out-dated. > > > > > > Hi Bill: > > > > > > There is an application, that was developed by programmers, from the > > > DBA, that goes through an existing database and extracts all the > > > objects into text files and than can rebuild a new database from > > > these files. This method is one of the purest methods to clean up a > > > database. I am not sure if it will work as there was some fixes to > > > do with the application but I had tested it and it really works. > > > > > > It has been a number of years ago and I just can not remember the > > > name or where a copy of this application is stored but I will look > > > for it and > > send > > > it to you when it is found. I am sure there must be other members > > > who remember the product and have it stashed away somewhere. > > > > > > Jim > > > > > > ----- Original Message ----- > > > From: "Bill Benson" <bensonforums at gmail.com> > > > To: "Access Developers discussion and problem solving" > > > <accessd at databaseadvisors.com> > > > Sent: Sunday, June 1, 2014 6:04:05 AM > > > Subject: Re: [AccessD] corrupt database - backup rather out-dated. > > > > > > I gave it a shot, it did create another database named Test but it > > > did > > not > > > work, had all the same errors I was getting before. > > > > > > Sub Try() > > > Dim D As Object > > > Dim strSource as string > > > Dim strDest as string > > > > > > strSource = "D:\Docs\zzzProgramming and Consulting\2014 Programming > > > Development\Lew\Lew DB2.accdb" > > > strDest = "D:\Docs\zzzProgramming and Consulting\2014 Programming > > > Development\Lew\Test.accdb" > > > Set D = CreateObject("DAO.DBEngine.120") D.CompactDatabase > > > strSource,strDest , , 128 End Sub > > > > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael > > Mattys > > > Sent: Sunday, June 01, 2014 8:46 AM > > > To: 'Access Developers discussion and problem solving' > > > Subject: Re: [AccessD] corrupt database - backup rather out-dated. > > > > > > Hi Bill, > > > > > > One more, you'll like this one: > > > > > > > > http://stackoverflow.com/questions/3133738/why-cant-i-use-compactdatab > > ase-in > > > -dao-dbengine-36-using-vbscript > > > > > > Michael R Mattys > > > Mattys Consulting, LLC > > > www.mattysconsulting.com > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill > > > Benson > > > Sent: Sunday, June 1, 2014 6:30 AM > > > To: 'Microsoft Access Database Discussion List'; 'Access Developers > > > discussion and problem solving' > > > Subject: [AccessD] corrupt database - backup rather out-dated. > > > > > > Posting to both lists because this is urgent My Ac2013 Accdb started > > > being corrupted for "no" (known) reason, my suspicion... maybe my PC > > > ran out of juice while on Standby, or maybe standby itself caused > > > the problem. It is completely unusable, I can open it and get an > > > error message that says > > 'Id' > > > is not an index in this table (it never tells me what table), about > > > 3 or > > 4 > > > times; then any object I try to open I get that same message 10 to > > > 20 times, including all modules and linked tables. Eventually some > > > tables will > > open. > > > Modules (which is what I am really after, I spent a lot of time > > > coding) never. I have not been able to import anything into a fresh > > > database either. > > > I cannot get to the VBE inside it. > > > > > > Does someone have a way to repair or crack this accdb open piece by > > > piece to get at its parts? I would be happy to send it to you, it is > > > just my work, no client data yet. > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >