Bill Benson
bensonforums at gmail.com
Sun Jun 1 21:22:17 CDT 2014
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