Re: Why am I getting this Error?
From: Steve (srockower_at_castcom.net)
Date: 03/14/05
- Next message: Atlas: "Access 2003 Debugger Woes"
- Previous message: Roy Goldhammer: "Allow Edits Property"
- In reply to: Allen Browne: "Re: Why am I getting this Error?"
- Next in thread: Allen Browne: "Re: Why am I getting this Error?"
- Reply: Allen Browne: "Re: Why am I getting this Error?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Mar 2005 06:36:41 -0500
Well, I've decompiled, compacted, de-referenced, and even copied into a
fresh .mdb file, and it still freezes and says "You can't carry out this
action at the present time" after I add transactions.
I did all this for both my front-end and back-end data files.
I will try to re-write the form and code to see if this makes a
difference.
Any other ideas? Thanks for your help.
Steve
Allen Browne wrote:
> The code looks okay, assuming that the field "Master" is actually a Text
> type field (not a Number type field). When drilling down like that, it can
> help to ensure that any edits are saved before progressing to the next form,
> so you might like to add:
> If Me.Dirty Then Me.Dirty = False
> to the top of the procedure.
>
> Steve, the symptoms you describe are typical of a corruption in the
> database, so I'm going to suggest a sequence to try to rescue it. Follow the
> steps in order.
>
> 1. Uncheck the boxes under:
> Tools | Options | General | Name AutoCorrect
> Explanation of why:
> http://allenbrowne.com/bug-03.html
>
> 2. Compact the database to get rid of this junk:
> Tools | Database Utilities | Compact
>
> 3. Close Access. Make a backup copy of the file. Decompile the database by
> entering something like this at the command prompt while Access is not
> running. It is all one line, and include the quotes:
> "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
> "c:\MyPath\MyDatabase.mdb"
>
> 4. Open Access, and compact again.
>
> 5. Open a code window.
> Choose References from the Tools menu.
> Uncheck any references you do not need.
> For a list of the ones you typically need in your version of Access, see:
> http://allenbrowne.com/ser-38.html
>
> 6. Still in the code window, choose Compile from the Debug menu.
> Fix any errors, and repeat until it compiles okay.
>
> At this point, you should have a database where the name-autocorrect errors
> are gone, the indexes are repaired, inconsistencies between the text- and
> compiled-versions of the code are fixed, and reference ambiguities are
> resolved.
>
> If it is still a problem, the next step would be to get Access to rebuild
> the database for you. Follow the steps for the first symptom in this
> article:
> Recovering from Corruption
> at:
> http://allenbrowne.com/ser-47.html
>
- Next message: Atlas: "Access 2003 Debugger Woes"
- Previous message: Roy Goldhammer: "Allow Edits Property"
- In reply to: Allen Browne: "Re: Why am I getting this Error?"
- Next in thread: Allen Browne: "Re: Why am I getting this Error?"
- Reply: Allen Browne: "Re: Why am I getting this Error?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
