Access 2007

[oberatixx]

I've been testing Windows 7 at my work for a few weeks now and I've run across an Access 2007 issue that I can't resolve. It happens when I open an Access database and it comes back with this error,

"The table is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."

I have no issues opening the files in Windows XP using Access 2007. I also tried opening the file when no one else has it open and no locks are on it and no luck. The database/s is running in shared mode.

Any help would be greatly appreciated.

 

[Irene]

You could first try running the Access MicroSoft Office Diagnostics:

1. Click the Microsoft Office Button
   
   , and then click Access Options.
2. Click Resources.
3. Click Diagnose, click Continue, and then click Start Diagnostics.

 

[oberatixx]

You could first try running the Access MicroSoft Office Diagnostics:

1. Click the Microsoft Office Button
   
   , and then click Access Options.
2. Click Resources.
3. Click Diagnose, click Continue, and then click Start Diagnostics.

It comes back and tells me there is nothing wrong.

 

[Irene]

You could first try running the Access MicroSoft Office Diagnostics:

1. Click the Microsoft Office Button
   
   , and then click Access Options.
2. Click Resources.
3. Click Diagnose, click Continue, and then click Start Diagnostics.

It comes back and tells me there is nothing wrong.

Perhaps the database is corrupted....

Extract below taken from here: Help prevent and correct database file problems by using Compact and Repair - Access - Microsoft Office


Compact and repair a database

• Automatically compact and repair a database when it closes
• Manually compact and repair a database

Automatically compact and repair a database when it closes

You can select the Compact on Close database option if you want to automatically compact and repair a database when it closes.
Note Setting this option affects only the database that is currently open. You must set this option separately for each database that you want to automatically compact and repair.

1. Click the Microsoft Office Button
   
   , and then click Access Options.

1. In the Access Options dialog box, click Current Database.
2. Under Application Options, select the Compact on Close check box.

Manually compact and repair a database

In addition to or instead of using the Compact on Close database option, you can manually run the Compact and Repair command. You can run the command when you have a database open, and you can run the command on a database that is not open. You can also create a desktop shortcut that runs the Compact and Repair command on a particular database file.
Compact and repair a database that you have open

Note If other users are also currently using the database file, you cannot perform a compact and repair operation.

• Click the Microsoft Office Button
  
  , point to Manage, and then, under Manage this database, click Compact and Repair Database.

Compact and repair a database that is not open

Note If other users are currently using the database file, you cannot perform a compact and repair operation. While you run the compact and repair operation, no one can use the database file.

1. Start Access, but do not open a database.
2. Click the Microsoft Office Button
   
   , point to Manage, and then, under Manage this database, click Compact and Repair Database.

1. In the Database to Compact From dialog box, navigate to and double-click the database that you want to compact and repair.