Solved

Windows 7, Access 2007 compact and repair issues

Posted on 2010-11-30
13
577 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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.

757 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

13 Experts available now in Live!

Get 1:1 Help Now