Solved

Windows 7, Access 2007 compact and repair issues

Posted on 2010-11-30
13
586 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
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!

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

756 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