MS Access 2003: The OpenReport action was cancelled

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.
urbanstylesAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
urbanstylesAuthor Commented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jeffrey CoachmanMIS LiasonCommented:
Then I would go with LSM's suggestion...
0
 
urbanstylesAuthor Commented:
I will try recreating the profile this weekend.

Thanks.
0
 
urbanstylesAuthor Commented:
Creating a new profile for the same user on the same machine worked.. go figure.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.