split db reports blank

[Jerry Stoner]

Im running a split db, currently only 2 users as we are still beta. When an operator tries to run a report from a form the report comes up blank. No data and no formatting. I mean litterally a blank page. You cant close it - an error message comes up You must stop the code from running or something to that effect. Go to design view same thing. The only thing that exits the blank rep is ctrl alt delete. It seems the db is still running the query behind the Report but we are only talking 230 records? If I take the db home it works fine. Ive checked references and that is not the problem.

BTW I cant check the query results during the problem because I'm stuck till I close the db with ctrl alt delete.
Any ideas?

 

[Vassago]

You said you had an error message, what error message did you have?

Are you running this database across a network? I've seen a LOT of slowdowns due to this, especially for queries in reports. It can take a long time at my workplace because our network is kind of old, but it works.

 

[Jerry Stoner]

Dont remember the exact message and it wasnt an error. It was basically indicating the code which runs a query for the report was still running even 5 minutes later but only 230 records involved and no more than 300 in associated tables. Yes its on a network. DB is compacted and repaired and I recently imported all objects to a new db, decompiled and recompiled. Hate to think its a network problem as eventually I need to have 30+ users.
Jerry