The error you are getting means some object is missing from the database. It
also appears that since it is happening when you open the database that there
is either a startup form identified or a macro named Autoexec which will try
to run when you open the database.
Try holding down the Shift key while you open the database. If someone has
not disabled bypasskeys, then it should open and you will be able to
troubleshoot the problem. Start by looking for a macro named Autoexec. It
there is one, see what it is running and trace through that. If there is no
Autoexec macro, then from the menu click Tools->Startup and see if there is
anything in the Display Form/Page: combo. If there is, then go into debug
mode and run that. You should be able to find where it is failing and what
object is missing.