Solved

MS Access 2003: The OpenReport action was cancelled

Posted on 2011-02-16
6
708 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
[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
  • 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Industry Leaders: 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

Suggested Solutions

Title # Comments Views Activity
Microsoft Access 32-bit or 64-bit? 11 59
SUBFORM on ACCESS 2013 8 35
Using a combo box to search a form. 3 36
Excel Import/Export Named Ranges and Values 4 30
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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.

734 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