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
oberatixx

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
Irene

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
oberatixx

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
Irene

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





Similar help and support threads
Thread Forum
Access 2007/2010 what is the differences
:DHi Guys I'm hoping someone out there can clarify my issue. I have Office 2010 installed on my 64bit win7 Pc; I have a training video for Access 2007 As I am not familiar with either Access 2010 or Access 2007 would it possible to have both versions’ installed on the same Pc? Basically I...
Microsoft Office
Any problems using Access 2007 database with Access 2010?
According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes? So why do I have the feeling that something is not going to work? Is it because I have...
Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
Microsoft Office
Fixing iso file..Need Access 2007
I am taking an Access class in school now and for some reason I cant find it on my computer anywhere. I thought it come with Office 07.. I dont know maybe im missing something. Basically i wondering how to fix an iso file because i tried to download access for free from my schools Free Software...
Microsoft Office
Cannot Scroll in Microsoft Access 2007
Hi, I have a little problem in Microsoft Office 2007 Access. My OS is Windows 7 Ultimate. I cannot scroll down/up the page/s with my mouse wheel. I have the mouse setup properly due to being able to scroll in all my other programs. Is there something that needs to be clicked on to allow scrolling...
Microsoft Office

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 02:29.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App