Question

  • Creator
    Topic
  • #2152886

    Access 2007 Error, NEED IMMEDIATE ASSISTANCE

    Locked

    by lavoier ·

    Good Morning,

    I am having an issue, each and everytime I open my Access Database. The database was working prior to the conversion of the 2003 to 2007 Microsoft Office. when we converted in my office, it worked for about two months, then a message began showing up…

    “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 made and all recovered objects will be placed in a new database. Access will then open a new database. The names of objects that were not successfully recovered will be logged in the ‘Recovery Table’.

    If someone knows what is happening to my system and how I can correct this in a way that will not let this occur again, PLEASE I”M BEGGING! I need this database for every day work….

    Thanks!

All Answers

  • Author
    Replies
    • #2927329

      Clarifications

      by lavoier ·

      In reply to Access 2007 Error, NEED IMMEDIATE ASSISTANCE

      Clarifications

    • #2927307

      More info here for you….

      by Anonymous ·

      In reply to Access 2007 Error, NEED IMMEDIATE ASSISTANCE

      http://technet.microsoft.com/en-us/library/cc178973.aspx

      Please post back if you have any more problems or questions.

      • #2927300

        HELP on Access 2007 Error Message

        by lavoier ·

        In reply to More info here for you….

        HI,
        Sorry but I already knew that stuff and it didn’t really assist me in determining the underlying issue I am having with Access. I can not open my database without getting the error message that my file is in an inconsistent state and that its creating a backup.

    • #2927302

      Convert an Access 2000 or Access 2002 – 2003 database

      by Anonymous ·

      In reply to Access 2007 Error, NEED IMMEDIATE ASSISTANCE

      To convert an Access 2000 or Access 2002 – 2003 database (.mdb) to the Access 2007 file format (.accdb), you must first open the database in Access 2007 and then save it in the .accdb file format.

      1. Click the Microsoft Office Button Button image, and then click Open.
      2. In the Open dialog box, select and open the database that you want to convert.

      Note If the Database Enhancement dialog box appears, the database is using a file format that is earlier than Access 2000. To continue, see one of the sections that follows: Convert an Access 97 database, Convert an Access 95 database, or Convert an Access 2.0 database.
      3. Click the Microsoft Office Button Button image, point to Save As, and then, under Save the database in another format, click the file format to which you want to convert.

      If any database objects are open when you use the Save Database As command, Access prompts you to close them prior to creating the copy. Click Yes to make Access close the objects, or click No to cancel the entire process. If needed, Access will also prompt you to save any changes.
      4. In the Save As dialog box, type a file name in the File name box, and then click Save.

      Access creates the copy of the database, and then opens the copy. Access automatically closes the original database.

      Convert an Access 2.0 database

      You can import tables, queries, and macros from an Access 2.0 database (.mdb) into an Office Access 2007 database (.accdb). You cannot, however, convert an Access 2.0 database to the Access 2007 file format by using Access 2007. To import forms, reports, or modules into an Access 2007 database, you first convert the database by using an earlier version of Access, then open the converted database using Access 2007, and then convert the database into an Access 2007 database. The following procedure explains these steps:

      1. Open the database in Access 2000, Access 2002, or Access 2003.
      2. Save the database in either the Access 2000 or Access 2002 – 2003 format.
      3. Open the database in Access 2007.
      4. Convert the database into an Access 2007 database.

      Import an Access 2.0 database into an Access 2007 file

      If you use an existing database in the Access 2.0 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb).

      To import forms, reports, or modules into Office Access 2007, you must first convert the database by using an earlier version of Access, open the database in Access 2007, and then convert the database into the Access 2007 database format.
      http://office.microsoft.com/en-us/access/HA102066241033.aspx
      ………………………………….

      Please post back if you have any more problems or questions.

      • #2927295

        CONVERT

        by lavoier ·

        In reply to Convert an Access 2000 or Access 2002 – 2003 database

        We had done this already when we implimented the new Microsoft Office 2007 program into our systems. We did this with out Access Training Technician. However, this person as well as several others we’ve contacted have no idea whats wrong with our databases. Its not an issue of the conversion, its a issue with the message that we’re receiving. We can not open the database without this message coming up. We have several other databases that we converted which are not creating a problem, just this one, and its our largest.

        • #2927288

          Ok, first i need to know WHAT you had done, step by step ..

          by Anonymous ·

          In reply to CONVERT

          I will be able to pick up your issue if you give the lay out of what happened before and after.
          I am going through my library trying to workout you issue from your post, but i need the Above info.

          Please post back if you have any more problems or questions.

        • #2927282

          Step By Step

          by lavoier ·

          In reply to Ok, first i need to know WHAT you had done, step by step ..

          1. implimented 2007 office programs….converted properly from 2003
          2. opened files to make sure working correctly
          3. began using databases and entering information
          4. database A (one in question) began to cause problems, creating own backups and opening in new database with recovered entries on seperate table
          5. went through manage in Office button, selected compact & repair to correct problem
          6. issue still persisting and message still popping up causing database to crash and screen to go blank with #### in all cells

          I hope this will help as we are finding it difficult to work

        • #2927275

          Right first off…

          by Anonymous ·

          In reply to Step By Step

          1). Make sure ALL users CLOSE the database, and then you open the database you want to compact and repair.

          2). Click the OFFICE button, and then point to MANAGE.

          3). Click Compact And Repair Database.

          Have you done and gone through the above?.

        • #2927272

          Compact & Repair

          by lavoier ·

          In reply to Right first off…

          Yes, when the database crashes, everyone using it, gets out. We move the backup which Access created into a seperate file folder on our network drive. Then one person does a compact & repair. Once its been completed, they notify the others that its been done and they can go back in and use it again. However, its still crashing and creating backups.

        • #2927267

          Make sure that your people are doing this…

          by Anonymous ·

          In reply to Compact & Repair

          If they need the backup copy of the database they can use the OPEN button to restore and view the data.

    • #2927268

      Ok, here is more info that will highlight your problem..

      by Anonymous ·

      In reply to Access 2007 Error, NEED IMMEDIATE ASSISTANCE

      What to do when your database starts acting erratically, or when even the simplest tasks cause Access to crash?. Problems of this type can occur when a database get corrupted or when the database file becomes too large. A database can become corrupted when, for example, Access suffers a system crash. Access can repair many of the problems associated with a corrupted database. The size of the database file may also be the trouble. When you delete objects such as forms and reports, Access does not reclaim the space they occupied. To use this space, you have to COMPACT the database, allowing Access to rearrange the data, filling in the space left behind by the deleted objects.

      • #2927264

        Okay

        by lavoier ·

        In reply to Ok, here is more info that will highlight your problem..

        okay, we have one main table and then run off of queries. We do not use forms, reports or anything other than the Queries themselves. I know this is a backwards way of using Access but its the way they were using it when I took this job. Now there are issues. None of my databases are corrupt, yet the one in question is the issue. it continues to cause problems, creating backups and loosing lines and enteries previous entered that day. Thus the database could state that it is 80,000kb and then once the backup is created in the system, the database now only shows 39,000kb. Is this an error or something gone wrong with the backup?

        • #2927257

          What amount of memory do you have on your server?.

          by Anonymous ·

          In reply to Okay

          It sounds that it tries to do a back up but then crashes out at the last minute. have a look at the amount of memory your server has and make sure that you have enough disk space for your server to do this or get the server to do a back up on a bigger disk. Just a thought.

        • #2927227

          Space

          by lavoier ·

          In reply to What amount of memory do you have on your server?.

          We have a massive server that runs all our systems. There is never a lack of space. It has nothing to do with the amount of disk space required. Our database isn’t even that large compared to others I’ve seen.

        • #2916710

          This does not answer my question..But never the less..

          by Anonymous ·

          In reply to Space

          Put it this way, how big is Massive?.
          I do not know your set up so that is why i am asking.
          People i deal with do not even know what “RAM” means let alone “hard drive”. A bit off topic there, but it gives you an insight on why i asked in the first place.

          So going on your Massive server on which you have a big problem with your database.
          You have given me a task to sort out, but in the mean time, i am going to give you a few links to some software in the hope it/they will get your database going. I think you will be interested with the number two link.

          http://www.freedownloadscenter.com/Best/free-mdb-repair.html
          http://www.everythingaccess.com/accessdatabaserepair.htm
          http://www.accessfilerecovery.com/

          Please post back if you have any more problems or questions.

    • #2916706

      A frind of mine said this to me, i hope this helps you..

      by Anonymous ·

      In reply to Access 2007 Error, NEED IMMEDIATE ASSISTANCE

      The compact and repair database option has moved in Access 2007. To run this feature click the Office button (upper left corner of the screen) select Manage from the list then select Compact and Repair Database and browse to the database.

      Please post back if you have any more problems or questions.

      • #2916678

        repair

        by lavoier ·

        In reply to A frind of mine said this to me, i hope this helps you..

        Its been found and used several times today. Thanks!

        I work for the University of Manitoba, in the CancerCare Manitoba Building. We have two rather large servers which hold the information for all of our computers. We have about 200 computers, laptops, and other wireless systems that run off of it. Not exactly sure how massive it is, but its pretty large!

    • #2868523

      Troubleshooting

      by matthew.weeks ·

      In reply to Access 2007 Error, NEED IMMEDIATE ASSISTANCE

      First off, try a compact and repair: Microsoft Office Button > Manage > Manage this database > Compact and Repair Database.

      • #2868520

        I’m guessing

        by boxfiddler ·

        In reply to Troubleshooting

        he’s figured it out by now. OP date is 2008.

Viewing 5 reply threads