Form Freezing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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
 
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
 
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.
 
Back
Top