Form Freezing

[Darren]

I am having problems with a database that I have designed. When I enter data
in to a form and want to add a new record the form freezes. The only solution
is to close the entire DB and re open it. I have checked and there is more
than enough memory on the drive on which the DB is.

Any ideas???

 

[Ofer]

Used to happen to me alot, the reason for it was in the load of the form I
had docmd.Echo false
when I removed it, everything worked fine.
The problem started when I moved from access 97 to Access 2003

 

[Jerry Iglowitz]

I LISTED A VERY SIMILAR PROBLEM ON THIS FORUM, BUT IT SEEMS YOU MIGHT
HAVE AN ANSWER TO IT, SO, WITH YOUR PERMISSION, I WILL RESTATE MY PROBLEM:

I sure could use some help on this one. I created a payroll program
years ago in Office 97 which used Access as a front-end for data entry
and display, (among other things), but the work was all done in a fairly
huge Excel spreadsheet which contained employee data, tax tables, and
individual records for each payroll event. This program worked just
fine under Windows 98, but when I updated it to run under Office XP,
strange things have been happening.

For one, the update times have slowed to a snail's pace -i.e. several
minutes for each event, and for two, it seems to be generating a new
linked table for each data entry event.

I am not that versed in the programs, but got to where I needed by brute
force, but I would definitely appreciate any help you can give me.
Please keep it as simple as possible, however, as I do not comprehend SQL.

Thanks in advance,

Jerry Iglowitz

 

[Ofer]

I had this problem only when running mde in run time, with the mdb I had no
problem, this why it was so hard to find it.
The form came up very slow and in most cases it got stuck.
When I removed this line everything worked fine, and the funny thing was
that it not always happened.
But since I removed it no problem at all, and it happen in few forms.