Solved

MS Access 2003: The OpenReport action was cancelled

Posted on 2011-02-16
6
688 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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…

776 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