50% of the time my report won't open

[Cero21]

Hi, sorry I'm not very well versed in Access but here goes.

I am running Access 2000 sp-3 and I made a whole bunch of reports using the wizard. 4 are made from single tables and 4 are made with queries that narrow down those single tables.

Now, when I go into access and try to click and open these reports from the database window(either preview or design) around 50% of the time nothing will happen. The small hourglass will appear for less than a second then nothing. I do not recieve an error msg or anything.

I also have a couple forms that will open these reports on a click and I get the same thing.

Anyone have any idea what is going on here? I would greatly appreciate any help. Thanks.

 

[Cero21]

Here's an update on my situation:

I had one of the database guys at work look at this (he said he has had extensive use of access). He said that he had never seen this type of problem before and that it seems to be some sort of corruption. The thing is, the reports not openning is not consistant and there is nothing wrong with the code. He thinks that it is something to do with Access 2000 because when we convert the db to access 97 it works fine. Also, when I tried the db on Access 2003 (at home) using the same Access 2000 db it worked fine. Any ideas?

GingerR - Can't seem to get the db out to you through email from work. I'll send it to you from home, probably tonight.

 

[GingerR]

Try making it a zip file.

This is a funky issue. Sometimes it's easy to find the problem, other times not. Corruption? Different references maybe? Hard to tell....

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html