Re: Compact and repair problems

enak wrote:
Any way, this morning when he tried to run the compact and repair utility he
got an error that states "Microsoft Access has encountered a problem and
needs to close". That is it.

Make a copy of the file and work only with the copy. Keep the original
intact in case you need to send it to a recovery company. Press the shift
key down while opening the copy so the startup code doesn't execute. Open a
module and compile the code if it's not compiled. Create a new database and
import all objects from this copy into the new database. Try compacting the
new database.

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Problems Splitting Database
    ... Launch Microsoft Access. ... I opened up all the modules and the compile ... >> Microsoft Access 2003 VBA Programmer's Reference ... >>> I've got a big database that I'm trying to split. ...
    (microsoft.public.access.modulesdaovba)
  • Re: A2K to Access XP
    ... > won't compile. ... > tried to tick the Microsoft Access 8.0 Objet Library but get the message ...
    (microsoft.public.access.conversion)
  • Re: Creating a mde from a 2002 mdb
    ... Can you compile the database BEFORE you try and make a mde? ... open the database (use the shift key if you got any startup code etc.). ... Edmonton, Alberta Canada ...
    (microsoft.public.access.modulesdaovba)
  • Re: MDE
    ... compiling until the compile completes with no messages at all. ... If you are using Access 2002 or 2003, the default database format is ... you cannot create an MDE. ... > I'm getting a message "Microsoft Access was unable to make an MDE ...
    (microsoft.public.access.forms)
  • Re: Converting from Access 2000 to Access 2002
    ... Open your database in Access 2000, ... Still in the code window, choose Compile from the Debug menu. ... converted database, it initially opens but, when I try to use it, I get ... message "Microsoft Access has encountered a problem..." ...
    (microsoft.public.access.conversion)