Solved

Windows 7, Access 2007 compact and repair issues

Posted on 2010-11-30
13
579 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
 
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…

861 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now