Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Access 2007

26 Jan 2011   #1

windows 7
 
 
Access 2007

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.

My System SpecsSystem Spec
.

26 Jan 2011   #2

Windows 7 Home Premium 64bit
 
 

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.
My System SpecsSystem Spec
27 Jan 2011   #3

windows 7
 
 

Quote   Quote: Originally Posted by Irene View Post
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.
My System SpecsSystem Spec
.


27 Jan 2011   #4

Windows 7 Home Premium 64bit
 
 

Quote   Quote: Originally Posted by oberatixx View Post
Quote   Quote: Originally Posted by Irene View Post
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

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.
My System SpecsSystem Spec
Reply

 Access 2007




Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:28 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33