Problem when saving form

[Bogdan Zamfir]

Hi,

I have a form in an Access 2000 database.
I made a small design change and try to save.
Than I had to wait .... till I give up and closed Access from task manager.
It seems Access locks-up

I tried this again, and looking in task manager, at Mem Usage while Access
try to save the form.
This value keeps increasing while Access works hardly to save my form (it
started to about 18 MB, and after 10 min it gets to 25 MB and increasing).

Does anyone encountered this?
It seems I cannot make the smallest change to my form, since I cannot save
it.
Although, I can run it.

The same things (veeery slow whan save) is happening with other forms too,
but since they are less complex than this one, they finally are saved.

Any suggestion will be appreciated.

Regards,
Bogdan

 

[Gary Miller]

Do you have any code that is still running in an
uncontrolled loop? Have you opened large recordsets that you
haven't explicitly destroyed? Have you compiled and saved
all of your modules lately?

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Van T. Dinh]

What Gary and since you used Access2K (a fair number of bugs in the original
release), make sure you applied all the Service Releases / Service Patches
to your Office installation.

 

[Bogdan Zamfir]

Hi,

I have Office 2000 Sp1a installed

There is no other form open. The mdb is open for design, so no code is
running.
No recordset was open at all, since I didn't started any code since I opened
the Mdb in Access.

Any other ideas?

Thanks,
Bogdan

 

[Gary Miller]

Bogdan,

Try importing everything into a new database container and
see what happens.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Bogdan Zamfir]

Already did it, no result.

Any other thought?

Cheers,
Bogdan

 

[Gary Miller]

I would consider trying a decompile and then recompile on
the db. Couldn't hurt.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Bogdan Zamfir]

Thanks, I forgot about this.
I'll try it, thanks

Bogdan

 

[Gary Miller]

Hope it works!

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________