Dan Owbridge said:
I have imported all the tables, queries etc. from one database to
another and now cannot get any of the event procedures to run i.e.
onclick open form.. The error message says error accessing file
Any help appreciated
If you're using Access 2000 and and service pack 3 hasn't been applied,
this KB article describes the nasty bug that has probably bitten you:
http://support.microsoft.com/default.aspx?scid=kb;[LN];304548
Office 2000 SP3 fixes the bug, but that won't repair your corrupted
database. You'll have to resort to a backup, or else try importing all
objects to a new database -- some objects probably won't import, and
you'll have to recreate them from scratch. When you do import the
objects, unless you've applied the service pack, it is *crucial* that
you compile and save the project before closing the database.
