?
Solved

Windows 7, Access 2007 compact and repair issues

Posted on 2010-11-30
13
Medium Priority
?
596 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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 85
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
Suggested Courses

719 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