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

Sun Jun 1 21:11:59 CDT 2014

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