Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    5

    Unanswered: jetcomp not reparing

    My database got corrupted when the system hung. It now gives the "another user is trying to change the same data at the same time" error.

    Repair and compact gives the same error, as does importing into another database.

    Downloaded the latest JetComp, but it says "can't compact this version of database"

    Using Access 2000, jetcomp 4.0

    help!

  2. #2
    Join Date
    Sep 2003
    Location
    UK
    Posts
    122
    Can you open the recordset Read-Only?
    Matt the Hat says: "what!?"
    A child of five could understand this! Fetch me a child of five!
    SCARY HARD CHALLENGE: http://www.dbforums.com/showthread.php?threadid=988682

  3. #3
    Join Date
    May 2003
    Posts
    5
    How?

  4. #4
    Join Date
    Sep 2003
    Location
    UK
    Posts
    122
    Originally posted by mendingo
    How?
    Useually if a record or table is locked and I try to open the table in design mode it offers to open as a ReadOnly ("snapShot" effectivly read only) and so I can view the data but not do much else.

    In code it would be

    Code:
    Dim rs As Object
        Set rs = Me.Recordset.Clone
    this allows you to programmaticly do things with the data without actually doing it to the record set.

    I lost data to corruption of an Access 2K database once. What we did was close the DB, restart the comupter and create a new database. Then we used the import data method to get all the data and tables and queries etc back.

    Try these ideas and tells us what happens

    BTW: have you installed the latest updates from MicroSoft?
    Matt the Hat says: "what!?"
    A child of five could understand this! Fetch me a child of five!
    SCARY HARD CHALLENGE: http://www.dbforums.com/showthread.php?threadid=988682

Posting Permissions

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