WHy does my report keep "Stalling" ?

[KingOf206]

I have a database where when you open it up a pop up form appears.



When I click on "ALT STATS" it takes you to a secondary pop up form. And on that form I click on "End OF Day Report". When I click on this report it just stalls and I am unable to open it up.

Can someone help tell me why it does this?

any help would be appreciated.


PS. My data comes from a "Linked Excel file" which I keep on my systems network so there wont be any data to pull. I am mainly looking for connection issues and why the report it self keeps stalling.


ALT_ElectionStats.zip

[aytee111]

Difficult to help you without data. Try importing the file to a local table instead of using the link and see if it is the report itself that is causing the issue or the connection to the file.

[KingOf206]

]

Difficult to help you without data. Try importing the file to a local table instead of using the link and see if it is the report itself that is causing the issue or the connection to the file.

Here is some sample data link this excel file to my database that I attached and it should work.

[ATTACH]26395[/ATTACH

[davegri]

Downloaded the db and spreadsheet, put both in same folder. Ran database, deleted the linked file from the M drive, linked the one from my drive, renamed it, and ran the report from the form. It ran instantly, quite a few pages.
You might consider copying the Excel file from the server and linking it locally.

[aytee111]

Did you try my suggestion? I cannot reproduce your problem, with it as an imported file or as linked. Does anyone else have that file open while you are trying to run the report? That will create the "stalling" while Access waits for exclusive access to it.

[KingOf206]

Downloaded the db and spreadsheet, put both in same folder. Ran database, deleted the linked file from the M drive, linked the one from my drive, renamed it, and ran the report from the form. It ran instantly, quite a few pages.
You might consider copying the Excel file from the server and linking it locally.

I tried to copy the excel file to my desktop and linked it from there. However I was unsuccessful. You have any other suggestions?

[davegri]

However I was unsuccessful.

Unsuccessful at the download or unsuccessful linking or ??? Any error messages?
If you hover over the table names in the navigation pane, it should show where the linked file is, drive, path, name.

[KingOf206]

Unsuccessful at the download or unsuccessful linking or ??? Any error messages?



If you hover over the table names in the navigation pane, it should show where the linked file is, drive, path, name.

I still have the same issue as before. I run the report (button that says "end of day report") and the report does show but it stalls and freezes once it loads. I am unable to view anything below what it shows and access just freezes up. What does this mean ?

[davegri]

What does this mean ?

Don't know. Neither aytee111 or I have that problem. You might go to control panel programs and features and try to reinstall/repair Office. Other than that, I have no suggestions.

[Micron]

Try
-database compact/repair
-renaming your report by appending OLD to its name, then bring in the report from the sample db you created. I'm thinking the original report might be corrupted, hence the compact/repair suggestion. The sample db report might be OK, which could explain why it works for others.
There are a few conditions that might provide clues:
Is this the only report that does this (assuming you have others to work with)?
Does it freeze at the header? Detail section? Which view, report or print? OK in design view?
The rest of Access is OK?
I wouldn't monkey around with Office just yet.