Report wizard locking up

T

TDC

I am trying to create a report via wizard and it keeps locking up. I've
removed some calculations in the main query to lighten the load per say, but
no help. Even the query takes a while to open. It is based on multiple
levels of queries, but this has never been a problem in my other databases.
Is there something I should look for? I am using 2003 version. It is a
split database with the back end on a server.

I am quite a novice and know enough about Access to be dangerous. Any help
would be appreciated.
 
F

Fred

Not much to go on to get really specific from but a few things that you might
try to narrow it down:

Assuming you're on the "front end" machine.

Like always, back up first.

See if it lets you make a report without the wizard. (i.e. via report
"Design View"
on the front end machine. )

Not sure what you meant by "multi level" query, but, whatever the
recordsource for the report is, see if you can open that directly.

Make a simple local DB on your local machine and see if the wizard runs.

Make a simple temporary table on the back end DB and try making a simple
report in the front end using report wizard.



Answers to the above may help clarify the source of the problem.
 
Top