Loosing form ojects

[magezi]

I have a database in ms-Acces 97. I'm using linked tables from another Ms-Access database . But whenever I run a macro which has to retrieve data from the linked tables and consequently update my tables , the process completes successifully, but later I fail to access some forms within my data base.I alwys run into an error like this:&quot;The form reffered to is mispelt or does not exist &quot;, but when I check for the same form it's alwys listed. if I try to open it by double clicking I get no response, If I try to delete it it doesn't disappear , If I try to rename it doesn't accept.<br>
<br>
Has someone ever experienced this ? If So what was the solution. I suspected It was a virus, but my Norton antivirus is upto date and it reported no virus presence upon a virus scan <p>Nkabirwa Sowed Magezi<br><a href=mailto:nkabirwa@netscape.net>nkabirwa@netscape.net</a><br><a href= > </a><br>A Ugandan Developer for<br>
(1) School Management Information System(SMIS) - Foxpro 2.6 ; Ms-Acess 97<br>
(2)Debt onitoring System(DMS) - Ms-Acess 97<br>
(3) The Loans Recovery System(LS) - Ms- Access 97<br>
(4) The Dry Cleaners System(DS) - Ms- Access 97

 

[elizabeth]

You may somehow be corrupting your database when you run your macros. Can you compact OK and do the objects show up as expected in the MSysObjects table? Can you import and export them OK?