Results 1 to 12 of 12
  1. #1
    Lounger
    Join Date
    May 2001
    Location
    Wellington
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unexpected state (2k sr1)

    Apologies in advance if this have been asked before. I couldn't find it...

    I have a client with a number of Access 2k databases which are stored on a file server, but generally opened by only one user at a time. Over the last few weeks, the databases have started to become corrupted at what seem to be random intervals.

    Symptoms are that when a user tries to open the database, Access responds with a lengthy message which starts with:

    'This database is in an unexpected state; Microsoft Access can't open it.'

    It proceeds to state that the database has been converted from Access 97 using DAO (which it hasn't), and then suggests restoring from backup.

    I can fix the problem in exactly that way, no issue, but does anyone know what could be causing it, and how to stop it happening?

    I can only find vague suggestions of network congestion causing problems from the Microsoft site.

    Any pointers most welcome.

    Thanks, Jim

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Unexpected state (2k sr1)

    Are these split databases (that is, with a frontend and backend)? And if so, is the frontend on the server or the workstations? This might be helpful in determining where the corruption is. Also, when someone works in the database, what are they doing? That is, are they just using doing normal data entry, reporting, etc., or they using design mode to change form/report designs, etc.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Lounger
    Join Date
    May 2001
    Location
    Wellington
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unexpected state (2k sr1)

    No, they aren't split. All three that are having problems are single databases, run from the server. There are another half dozen databases onsite which are run the same way, and are not having problems. All the databases have been around for a long time, with upgrades from Access2, and then 97, without any major changes in the last few months. The users are just doing normal duties, not design, and the problems seem to have suddenly occured in the last few weeks, with no apparent system changes.

    And that's the strange thing. I don't think it's a specific database, but rather a specific network/version problem.

    I am following up another possibility however. I'm wondering if some of the machines are running SR1 and some are not...

    Any other ideas?

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Unexpected state (2k sr1)

    You may be on the right track with the version solution. Next time you do have a problem, you might try to get into the database from each of the user workstations. I'd be curious if one of them let's you in but the others don't.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    Lounger
    Join Date
    May 2001
    Location
    Wellington
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unexpected state (2k sr1)

    That's a good point.

    What I've done in the meantime is to cobble together some code which creates a new entry in a log table in another database every time the app is started. It logs userid, machine name, time, and Access version, and then completes the record when the user leaves by adding a logoff time.

    Analysis of this table just might give me what I need. Of course now I need to wait until it falls over again...

    Now that I've got this far though, I might polish this stuff up, and make it available.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Unexpected state (2k sr1)

    you wrote:
    >>Now that I've got this far though, I might polish this stuff up, and make it available.<<

    Sounds like it would be worth seeing.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    New Lounger
    Join Date
    Mar 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unexpected state (2k sr1)

    FWIW, I received a damaged database w/ this exact problem... similarities to the poster, is that it is a single MDB and not an FE/BE solution. This database is not mine and tried the methods mentioned before which was to do repair compact from inside access but to no avail, then I did a /decompile, also to no avail, and finally a /repair from the command line and of course still to no avail... I tried running the JetComp 4 utility on this mdb and still no luck. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15> Part of the error message also suggest that I might be able to save the data if I export everything to a new mdb, but the mdb window never opens that far and thus I'm not able to do this... Of course the database has been restored now, so it's not like this is a *HOT* issue but I would like to know how to fix it should it come up again... any ideas yet so far?

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

    Re: Unexpected state (2k sr1)

    Just for the record: when a database is seriously damaged, there is little point in trying to *export* database objects from it, since you need to be able to open it to do that. Instead, create a new blank database, and try to *import* all database objects from the damaged database into the new one. This has the advantage that you can select multiple objects to be imported in one fell swoop, whereas exporting has to be done object by object, and even more importantly, Access doesn't have to open the database in the interface to import objects from it; it is opened at a lower level.

  9. #9
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Unexpected state (2k sr1)

    You probably are to the point where conventional means are no longer effective. You probably would need the help of a professional recovery service.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  10. #10
    New Lounger
    Join Date
    Mar 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unexpected state (2k sr1)

    This is true... I found a place on the web http://www.officerecovery.com/access/index.htm that does do a recovery, testing with their demo it proved fruitful, but it for $400 it hardly seems worth it to me at this present time, if anything I don't think it was worth $400 to the client... but for other situations were it a month old backup then it might be worth the money. The question at hand is... how did they do this? DAO? hacked the headers... ???

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unexpected state (2k sr1)

    You can actually open a database file in a text editor, and that's probably the approach they used. The problem with doing that is that it trashes the file as a database, so it's something you only do as a last resort when you need to recover whatever you can and there is no other choice. It's even possible that something like that is what trashed your database in the first place, a user accidentally opening an MDB in Word, etc. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  12. #12
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Unexpected state (2k sr1)

    I don't really know how they do it. I'm sure they know the data structure of a database, and they probably know what causes the typical "you can't get in" messages.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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