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

Bill Benson bensonforums at gmail.com
Sun Jun 1 12:54:34 CDT 2014


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
>


More information about the AccessD mailing list