Form Freezing Problem

[mcbass1]

I have a form running off of one large query that is running fine, although it takes about 12 seconds for it to load. My problem is that this last week, I've been having a problem with it freezing when I try to save changes to it. At first, I thought it was a problem with my pc, but it's locking when I access it from a handful of pc's. Now, I can't do any updates to the form.

Any information you can provide would be greatly appreciated.

Thank You,
Mike

 

[Zaeed]

have you done a compact and repair on the db?

 

[mcbass1]

I have compacted and repaired the database. I'm finding out that it's only freezing if I go directly into design mode on the form. If I run the form and then go into design mode, it doesn't freeze.

The form is designed from a query that only shows the employees of the person logged into that computer, so I don't know if that would have something to do with it.

Mike

 

[mcbass1]

Now that I think of it, I have compacted and repaired the front end where the form is, but I have not compacted and repaired the back end. Do you think that could be the problem?

Thank You,
Mike

 

[CraigDolphin]

Another thing you can look at is whether debug>compile (in the vba editor window) turns up any problems in the code module of the form.

Though why it would freeze when going straight into straight into design view is beyond me....the pessimist in me wonders if there's some corruption that has snuck into your frontend/form somewhere.

If so, then try creating a clean, new database object and importing everything from your frontend into it. Sometimes that gets rid of the corruption if it's not too bad.

There are more things to try if that fails (decompile>recompile) etc but I'm sure you'll find loads of threads on database corruption if you search the forum.

 

[mcbass1]

I kicked out my users and compacted and repaired the backend. It went from 333mb to 194mb, and it seems to have fixed the problem, although it is still a little slow.

Thank you very much for the advice.

Mike