Bill-
When I "repair" a form or report, I strip it down to its bare essentials.
As you might expect, I'm using SaveAsText / LoadFromText with an edit of the
raw text file in between.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Wednesday, July 03, 2013 5:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Error 3343
John
That code is beautiful! Thanks for sharing it. I haven't had to repair a db
yet, but it's nice to know I now have a utility to do it.
I would have thought that removing the code would blow up the form. Doesn't
the checksum get messed up?
Bill Mosca
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...>
wrote:
>
> Bill-
>
> If someone opened your file in 2010 or 2013 and made any design
> changes to any forms or reports, you can no longer go back to 2007.
> Those later releases add an unsupported "empty" control to enhance the
> features available for Control Layouts. You could try my FixBroken
> utility that you can find in Files / 0_Utilities And Add-Ins on the
> forum website. Note that you may have to open the database in 2010 to
> be able to load my utility and run it to export all the objects - be
> sure to do this in a COPY of your database. Create a new empty
> database in 2007 and use my utility to reload all the "fixed" objects.
>
> Good luck,
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications SQL Queries for Mere Mortals
> http://www.viescas.com/ (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill
> Mosca
> Sent: Tuesday, July 02, 2013 11:43 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Error 3343
>
> Bill
>
> Something corrupted your file(s). It might be just the FE or the BE
> but it could be both although that is unlikely.
>
> Work on the back end first. See if it can be repaired. If that goes
> well your FE might suddenly start working again. If not, try
> decompiling a copy the FE. Decompiling instructions here:
> www.fmsinc.com/microsoftaccess/performance/decompile.asp
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427
> 073088
> 1E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Singer"
> <Bill.Singer@> wrote:
> >
> >
> >
> > I have a split database.
> >
> > Today I try to open the FE and I get this message.
> >
> >
> >
> > Run-time error '3343':
> >
> > Unrecognized database format
> >
> >
> >
> >
> >
> > I am running access 2007
> >
> >
> >
> > This database has been running fine for months with no issues and
> > then
> this.
> >
> >
> >
> > When I tried to open the BE I got this message.
> >
> >
> >
> > Microsoft Office Access has detected that this database is in an
> > inconsistent state, and will attempt to recover the database.
> > During this process, a backup copy of the database will be mane and
> > all recovered objects will be placed in the new database. Access
> > will then open the new database. The names of objects that were not
> > successfully recovered will be logged in the "Recovery Errors" table.
> >
> >
> >
> >
> >
> > Can anyone give me an idea of what is going on or what I need to do
> > to fix this?
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Bill Singer
> >
> > Minnesota
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar