Results 1 to 11 of 11
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error when opening database (2003)

    Perhaps the logon form has become corrupt, or the table it's bound to (if any).
    Start by making a backup copy of the database.

    Try this first:
    - Open the database with Shift held down.
    - Select Tools | Database Utilities | Compact and Repair Database.

    If that doesn't help:
    - Create a blank new database.
    - Import all objects from the problem database.
    - If one ore more objects can't be imported, they are the culprit(s). See if you can import them from an older non-corrupt backup copy.

    If that doesn't help either:
    - If you can find the database object that causes the problem, try to delete it, then to re-create it from scratch.
    - Or go back to an older non-corrupt backup copy.

  2. #2
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Error when opening database (2003)

    Subject edited by HansV because "Help" wasn't very helpful

    I have a database which opens with a form for users to logon. I just tried loging in, and got the Microsoft error message, and the option to backup the database. If I go into the database using the shift key, then open the logon form, it's ok. Can anyone advice me what the problem could be?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error when opening database (2003)

    It might also be worth trying a decompile - this has helped me out more times than I care to remember :

    http://www.trigeminal.com/usenet/usenet004.asp

    Nick

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error when opening database (2003)

    <RISKS TO DECOMPILE: WHY YOU SHOULD NOT USE IT CONSTANTLY>

    I use a2k (9.0.6926) SP-3 Jet 4.0 SP-8 and decompile 4 different applications several times a month and have always had great results.

    Have any Loungers had a bad experience with decompile?

    Thanks, John

    I use a bat file to zip a backup and run the decompile on original mdb:

    DecompCl.bat
    del CleckDc.zip
    wzzip -a ClerkDc Clerk.mdb
    "C:Program FilesMicrosoft Office2kOfficemsaccess.exe"
    "F:Appsaccess2kClerk.mdb” /decompile

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error when opening database (2003)

    I decompile databases quite often; I have added Decompile (and Compact) to the right-click menu for .mdb files. Many of the sample databases I post in the Lounge have been decompiled, then compacted to reduce file size. I very rarely encounter problems with it - once or twice I found that event procedures had lost their connection to the control they belong to, that's all.

  6. #6
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Error when opening database (2003)

    Thanks for all your advice. I took Hans advice, and found an old working copy, and transferred tables/forms over one by one, trying to logon each time. Still no joy until I transferred the logon form. It must have got corrupted, because as soon as I transferred it, I could logon. Any thanks to everyone for their help and advice, and I would like to wish you all a very merry christmas, and a happy new year. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  7. #7
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Error when opening database (2003)

    where can I get whatever it is that puts the decompile option in the reight-click menu?
    Thanks
    chuck

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error when opening database (2003)

    You can create it as follows:
    - Start Windows Explorer.
    - Select Tools | Folder Options...
    - Activate the File Types tab.
    - Select MDB in the list of file types.
    - Click Advanced...
    - In the Edit File Type dialog, click New...
    - Enter Decompile in the Action box.
    - Enter "C:Program FilesMicrosoft OfficeOffice11MSACCESS.EXE" /Decompile "%1" in the Application used to perform action box
    - In the above, use the appropriate folder. This is usually Office for Access 2000, Office 10 for Access 2002, Office11 for Access 2003 and Office12 for Access 2007.
    - OK your way out.
    - You should now have a Decompile option in the right-click menu for .mdb files.

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Error when opening database (2003)

    I have never had to use the decompile option at home, only on client sites.
    I have set this up at home now, could be very handy.
    Thank you Hans

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Error when opening database (2003)

    You can add Compact to the right-click menu the same way, using the following command in the "Application used to perform action" box

    "C:Program FilesMicrosoft OfficeOffice11MSACCESS.EXE" "%1" /Compact

    Again, replace Office11 with the appropriate folder for your version (see my previous reply).

  11. #11
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Error when opening database (2003)

    Good to know, thanks Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •