John or Bill,
I'm trying to run this code. I've successfully exported everything and am trying to import into a new database. I keep getting the warning that I must turn off autocorrect and I do, but when I open the db back up the Track name autocorrect is unchecked but Perform name Autocorrect is checked again and grayed out. I'm running Access 2010. Any ideas?
Doyce
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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 (7) |
Tidak ada komentar:
Posting Komentar