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-6427073088
> 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
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar