Ask Experts Questions for FREE Help !
Ask
    tushar_more99's Avatar
    tushar_more99 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Oct 14, 2006, 12:17 AM
    Error Number 3197: msAccess
    Error number 3197 : The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

    My MS Access File has been corrupted, how to repair this file
    Curlyben's Avatar
    Curlyben Posts: 18,514, Reputation: 1860
    BossMan
    		  
    #2

    Oct 14, 2006, 02:58 AM
    This article gives a full break down of your problem.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Oct 14, 2006, 05:39 AM
    The article Ben linked to shows you how to attempt a compact and repair. Hopefully that will work. If it doesn't work let us know there might be other things you can try.

    Once you have gotten the database fixed, you should take steps to prevent this happening again. If this database is a multi-user app it NEEDS to be split. Splitting involve taking all the tables and putting them into a back end file. Access includes a wizard (under Tools>Database) to do this for you. The wizard creates the new file, moves all the tables into it and creates links in the front end to those tables. You then put a copy of the front end on each user's PC.

    You also need to create a backup policy so you have a backup copy of both the back end and the front end at least daily.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Oracle Error 12560:tns Protocol Adapter Error [ 3 Answers ]

Hi, Whenever I try to log in using SCOTT/TIGER userid, I get the error "ORA ERROR 12560:TNS PROTOCOL ADAPTER ERROR". I tried starting the listener from administration-> services, but still the problem persists. Can you please suggest a solution?

Number sequence [ 2 Answers ]

What are the next three rows in the sequence: 1 11 21 1211 111221 312211 13112221

Part Number [ 1 Answers ]

I am trying to find a replacement for a Bryant CK3BXA048 "N" Coil. I haven't been able to find a matching number. It is a 4 ton horizontal coil. Can you make any suggestions?

About msaccess. [ 1 Answers ]

How to convert .mdb into .exe file??

Security Number [ 4 Answers ]

Hello! My name is Valentina (similar with Snt.Valentine's Day!):p I came from Russia by K-1 visa to Minnesota. I've already understood that law s are a little bit different in each state:confused: By my visa I had 90 days to marry to american citizen. We already married on November. Now we are...

View more questions Search