[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