Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Access 2007 database error 3197

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 04-05-2009
Member
 
Join Date: Nov 2008
Posts: 1,192
Access 2007 database error 3197
  

I have a concern on my Access 2007 database that I can not open because I get this message:

"The database engine Micro Jet has stopped the treatment because you and another user attempts to modify the same data at the same time"

The support indicates a 3197 error and need to use the Update method to solve the problem.

Can anyone enlighten me on this error to achieve my target?

Reply With Quote
  #2  
Old 04-05-2009
Member
 
Join Date: May 2008
Posts: 979
Re: Access 2007 database error 3197

Your database is shared by several users? Have you tried to make a copy elsewhere? Describes how little you use this database (single, shared on a network, ...)
Reply With Quote
  #3  
Old 04-05-2009
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: Access 2007 database error 3197

Yes, this is shared by several users. At the time, where the problem occurred, only one user was on that database.

Thank you in advance for your help.
Reply With Quote
  #4  
Old 04-05-2009
Member
 
Join Date: May 2008
Posts: 979
Re: Access 2007 database error 3197

The simplest:

1) Create a new Access database
2) Import that to the new
3) Tested that it's OK
4) Replace the damaged by the new

Finally my advice on Access: NEVER use the network. This is not a reliable database and sooner or later you will inevitably be have corruption of data. Access to possibly use the client interface (forms, reports, ...), but stores the data in that is more seriously.

You can use SQL (for example)
Reply With Quote
  #5  
Old 04-05-2009
Member
 
Join Date: May 2008
Posts: 913
Re: Access 2007 database error 3197

Repair a damaged database

The following steps can be used to try to repair a damaged database:

1. Make a copy of the damaged database (.mdb) file so that you have a backup.
2. Delete the .ldb file if it is present. You must close the corresponding .mdb file before you delete the .ldb file.
Quote:
The .ldb file is used to determine which records are locked in a shared database and by whom. If a database is opened for shared use, the .ldb file is created with the same name as the corresponding database (.mdb). For example, if you open the Northwind.mdb sample database for shared use in the C:\Msoffice\Access folder, a file named Northwind.ldb is automatically created in the same folder. The .ldb file is automatically deleted after the last user has exited the database with these two exceptions -- when the last user does not have delete permissions to the folder containing the .mdb file or when the database is corrupted. The .ldb file contains a list of users who have the database open.
3. Run the Compact and Repair utility. To do so, follow these steps:
  • If the database is open, close it.
  • On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
  • In the Database to Compact From dialog box, select the file that you want to compact, and then click Compact.
  • In the Compact Database Into dialog box, enter a new file name, and then click Save.
    Quote:
    If the compact and repair does not succeed, you will receive a message stating so. This means the damage is so severe that it cannot be corrected.
4. If the previous steps fail to recover your damaged database, try creating a new database and importing the objects, one-by-one, from the old database to the new one. Then re-create the relationships. This technique resolves problems with damaged system tables in the database.
Quote:
Note You cannot import data access pages with the Import Wizard. Instead, open an existing data access page in the new database. To do so, follow these steps:
1. In the Database window, click Pages under Objects.
2. Click New.
3. In the New Data Access Page dialog box, click Existing Web page, and then click OK.
4. In the Locate Web Page window, browse to the location of the data access page.
5. If the damage is in a table, and the previous steps have not recovered the table, try the following:
  • In Microsoft Access, export the table to an ASCII (delimited text) file.
  • Delete any relationships associated with this table, and then delete the table from the database.
  • Compact the database.
  • Re-create the table and any relationships it had.
  • Using a word processor, examine the ASCII file for bad or strange data and remove those records. Save the file in an ASCII text file format.
  • Re-import the ASCII file into the newly re-created table.
  • Re-enter any records that you were forced to delete.
6. If the damage is in a form or a report, the damage can be either in the form or the report itself or in one or more controls on the form or the report. You can delete the form or report and import it from the backup copy of your database or use one of the following options:
  • If the damage is in the form or report itself, create a new form or report, and then copy the controls from the original form or report.
  • If the damage is in a control on the form or the report, create a new form or report, and then re-create the controls on the new form or report. It is best to re-create all the controls, because there is no way to tell which controls are damaged.
7. If the damage is in a macro or a module, the damage can be in the macro or the module itself or in the contents of the macro or the module. You can delete the macro or the module and import it from the backup copy of your database or use one of the following options:
  • If the damage is in the macro or module itself, create a new macro or module, and then copy the contents of the original macro or module.
  • The damage could involve non-ASCII characters embedded in the module. Save the module as a text file, remove any bad or strange data, and then reload the text file into a new module.
  • If the damage is in the contents of the macro or module, you must create a new macro or module, and then re-create the contents of the original macro or module.

For more information about this topic, see this How to troubleshoot and to repair a damaged Access 2002 or later database.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Access 2007 database error 3197"
Thread Thread Starter Forum Replies Last Post
Access 2010 file in Access 2007 gives Unrecognized Database Format Roakman MS Office Support 3 11-12-2010 11:45 PM
How to defend Microsoft Access 2007 database from copying yummy- Windows Software 5 30-11-2010 11:22 PM
error message appears when saving design changes to a database in MS Access Ander K Windows Software 3 28-11-2010 01:13 AM
Access database error 800a0cb3 after migrating server Wyvern Software Development 3 31-10-2009 06:26 PM
convert filemaker pro database to access database Czack MS Office Support 3 15-04-2007 01:06 AM


All times are GMT +5.5. The time now is 08:27 AM.