Error Message

[Loi]

Hi,
Anytime I close a database, I revieve a message like that
MSACCESS.exe has generated errors and will be closed by
Windows. you will need to restart the program.

An error log in being created.

Please tell me what i need to do to fix the problem.

Thank you
Loi

 

[Stephen White]

How you tried the Detext and Repair under the help menu. You will need the disk.

 

[Pieter Wijnen]

This is a common problem in access '97 (at least) if you don't explicitly
close Recordsets after use
ie
Dim Rs AS DAO.Recordset

Set Rs = ....

' do things
Rs.Close : Set Rs = Nothing

HTH
Pieter