Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Can't Open Reports

Posted on 2004-09-24
10
Medium Priority
?
1,702 Views
Last Modified: 2010-08-05
I have an Access 2003 db I have been working on for a couple of weeks. When I opened it today, it wouldn't allow me to open any reports. I can't open them in either design or preview view.

Can anyone suggest a way to get it working again?

The only real clue I've found is that if I select one of the reports, and go to Tools/Security/User & Group Permissions, it is listing the reports as being owned by Admin. Admin is not a user name on either my PC or network. If this is the issue, how do I remove all ownership information. I need these files to work for anyone without nasty messages.
0
Comment
Question by:gbentley
[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
  • 4
  • 2
  • 2
  • +1
10 Comments
 
LVL 9

Expert Comment

by:solution46
ID: 12141088
Admin is the name of the default Access user if there is no security set up and is probably nothing to do with your problem (if you have Access security set up that is a different matter!).

This may be down to a problem with the underlying tables & queries - have you checked that these will open correctly? If not, please post the relevant error message and we'll take it from there. If the tables & queries open OK, you may have a corrupt database file. Try compacting & repairing the database (I've never had a problem with this process but back up the database first just in case). Failing that, try importing the reports into a blank databse. If that works, import all the other objects and use the new file.

Post any error messages you get working through this and we'll see what we can do.

Regards,

s46.
0
 
LVL 28

Expert Comment

by:burrcm
ID: 12141091
Admin is built into the default workgroup. Shouldn't be a problem. Likely your db has become corrupted. Pretty common with Access. Create a new blank database, then import everything from your current db (File - Get External Data - Import. Go to each tab and select all). This should get you back to normal.

Good luck

Chirs B
0
 
LVL 28

Expert Comment

by:burrcm
ID: 12141098
Go James. Beat me by that much. The Solution 6 folks might like to talk to your legal people however.

Chris B
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 9

Expert Comment

by:solution46
ID: 12144127
Chris B: looks like we agree, at least!!

One of the things that s46 does NOT do is accounting... not my cup of tea at all. More stock control systems, asset management, project management, organisation management, hr and so on. It has basic ledger support but the idea is to interface with Sage / Navision / similar for accounts. Cheers for the comment, though.

s46.
0
 
LVL 5

Author Comment

by:gbentley
ID: 12156840
Tried copying the reports in the same db, copying to a different db, running Repair and Compact, no change. Don't get an error message, just no open.

When copying the report in the same db, and trying to open it, a table called "Name AutoCorrect Save Failures" appears with a single record. The failure reason is "Could not open the object".

Anyone got any more ideas?
0
 
LVL 5

Author Comment

by:gbentley
ID: 12157427
More information.

I have un-installed Office 2003 (and all other versions), and re-installed including SP1. I find that I can't create, view, or edit reports in any database, even a new one.

Stranger and Stranger.
0
 
LVL 5

Author Comment

by:gbentley
ID: 12157835
I have now carefully removed all traces of all versions of Office, re-installed Off2003, and SP1. Still can't edit existing reports or create new ones in any database I have including a new one.

Help!
0
 
LVL 5

Author Comment

by:gbentley
ID: 12157957
Problem solved!

After reloading Office 2003 4 times with no change, I decided to try loading Office XP to see if it would work. Tried to open reports in Access and this time got an error message talking about the report possibly being formatted for a different printer that no longer exists. "Aha" says me, a clue. So, I switch printers and suddenly everything works again. Switch back, no reports.

Very strange, but at least I'm working again.

I'll post a message in community service asking to get my points back and close this question so others can find it.


Thanks
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12202746
Question answered by asker or dialog valuable.
Closed, 125 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

730 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