Solved

Windows 7, Access 2007 compact and repair issues

Posted on 2010-11-30
13
584 Views
Last Modified: 2012-06-22
Here is where I am at:
1.  Just upgraded to the Windows 7 operating system.  
2.  Am using Access 2007
3. The compact and repair worked fine under XP
4.  Under 7 it creates a duplicate database but now does not replace original database and does not delete old
5.  The access programs are on a server
6.  If I login in as administrator, I have no problems.
7.  Compacting and repairing on the C drive causes no issues
8.  Have given myself full control over the folder through Sharing
9.  Have added myself to the administrator's user group with full permissions

Where do I go from here?
0
Comment
Question by:rockydee
13 Comments
 
LVL 75
ID: 34241791
Certainly does sound like a permissions issue, in that Access cannot Delete the old db after compacting.  Possibly a Trusted Location issues ?

mx
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34242224
I have Access 2010 on a laptop running Win 7, I could not replicate your issue....
FWIW
0
 

Author Comment

by:rockydee
ID: 34242327
I added the directory with my Access programs to the Trusted Locations list and checked off that all sub folders should be trusted as well.  Made no difference.  It still creates the duplicate database without replacing the original and deleting the old.  

Boag2000 - how are you logging on and what permissions do you have?
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34242541
It is just a one user laptop...

I just wanted to see if it was login related.
0
 

Author Comment

by:rockydee
ID: 34242581
It has to be either a login issue or Windows 7 setup.  I opened one of my databases on a co-worker's laptop under his login.  His laptop also has Windows 7 and Access 2007.  I had no problems with compacting.  It did what it was supposed to do: compacted, renamed, deleted old.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34242744
So I guess you will have to examine the permissions of both users closely...

Were both computers loaded with Office 2007 in the exact same way?
0
 

Author Comment

by:rockydee
ID: 34243131
Examined the permissions of both users - no difference.  Just for kicks, I logged in as myself on my co-worker's laptop.  Had no problems with the compact and repair.  I had also reloaded Office 2007 making sure that I asked that everything be run from my computer.  Am I safe in assuming that this should have resolved any issues with a difference in the installation of Office 2007?  If it does, am I then left with an issue with the Windows 7 install?  I also rebooted my computer after the re-install and after each change in the permissions on my user profile to no avail.
0
 

Author Comment

by:rockydee
ID: 34243384
Another curious note.  If I open an Access 2007 database on a server other than the standard one I use for development, I do not have any issues with compacting, renaming and deleting.  What gives?
0
 
LVL 84
ID: 34247326
<The access programs are on a server>

When you're compacting, if you move the program off the server and place it directly on your laptop, do you have the issue? I think you clarified that in your post, but I'm not sure.

If you can do this (i.e. compact directly on the laptop) but still cannot do so on the server, then it's a permissions issue at some level. You may also have a corrupt User profile on your Win7 laptop - try creating a new User on the laptop with the same permissions and see if that new user can perform the Compact.

If not, then there's something amiss in the permissions. Might be a good idea to use the Request Attention button to ask the Moderators to add the Microsoft Server zones.
0
 

Author Comment

by:rockydee
ID: 34249488
Thanks for your feedback.  I do believe you are right about the permissions.  If I move the databases to another server, I have no issues.  I don't think it is a corrupt profile because my profile works fine for everything else and every where else - just not on this one server.  It seems to affect all of the directories on the server since I tried moving a database to a different directory and had the same results.  Until this is resolved, I have moved the databases to a server where things work properly.  I am also going to bump this up to the Moderators.
0
 

Accepted Solution

by:
rockydee earned 0 total points
ID: 34764004
Sorry about not coming back to this sooner.  What caused the problems was that we did an upgrade from Windows XP to 7.  Once we did a total, fresh install of Windows 7, all of the problems disappeared.
0
 

Author Closing Comment

by:rockydee
ID: 34824164
The reason for accepting this solution is that all other suggested solutions had to do with permissions.

The reason for a B is that we should have considered this as a possible cause much sooner than we did.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question