Solved

MS Access 2003: The OpenReport action was cancelled

Posted on 2011-02-16
6
696 Views
Last Modified: 2012-05-11
We have a custom Access database that we are using amonst 60 ish users shared off of a Windows 2003 SBS server.  All users can access the .mde file properly save one person.  He is on a newly rolled out Windows 7 machine that has Office 2003 SP3 and all current windows updates installed. When trying to generate on particular report he receives the error on click 'The OpenReport action was cancelled'.  Other users on Windows 7 can use the .mde just fine as well as all existing XP users.  All users have the same release of Office.  Does anyone have any idea what could be causing this one user to have an issue with a common database file?

I have been working witht the database developer for an answer, but he doesn't seem to have any more insight than I do into the logic of how only one user with seemingly nothing unique is having this issue.

I welcome any help any may have.
0
Comment
Question by:urbanstyles
  • 3
  • 2
6 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 34912658
First: Do you mean you're sharing a SINGLE file off the server? That's generally not a good idea, since it can significantly impact performance.

Regarding your user: Have you tried removing and recreating the User profile on the server? Corrupt profiles can cause troubles. If that user moves to a different machine and logs in, does the trouble follow them?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34918739
Do you have any security set up? (Access security or Network Security)
Perhaps this user does not have all the same permissions as everyone else?
0
 

Author Comment

by:urbanstyles
ID: 34918872
User has identical permissions to everyone else.  Worked fine on his old computer, new machine is when the issue started. It's a very small database so performance is not an issue.
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: 34920076
Then I would go with LSM's suggestion...
0
 

Author Comment

by:urbanstyles
ID: 34920143
I will try recreating the profile this weekend.

Thanks.
0
 

Author Closing Comment

by:urbanstyles
ID: 35087101
Creating a new profile for the same user on the same machine worked.. go figure.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
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.

685 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