Jim Dettman
jimdettman at verizon.net
Mon Jun 2 06:55:06 CDT 2014
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