[AccessD] corrupt database - backup rather out-dated.

Mon Jun 2 00:00:17 CDT 2014

Sure, shoot it off to me.

Doug

On Sun, Jun 1, 2014 at 7:22 PM, Bill Benson <bensonforums at gmail.com> wrote:

> 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
>