Albert D.Kallal <pleasenooospammkal...@msn.com>

There has been a few posts that suggest that having code windows open can
case this..

Try he following:

exit the application

re-enter the application (hold down the shift key if you have any startup
forms..or any startup code that runs when the application loads).

now try a compact and repair. If this don't work..then I would suggest that
you create a new blank database..and import everything into this...can you
compact that one?

It sounds like you have a improper shutdown or free up..and the mdb files is
now damanged....

Also, what format of mdb file are you using...(the default is 2000...but
give the 2002-2003 format a try).

--
Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKal...@msn.com
http://www.members.shaw.ca/AlbertKallal