database not recognised as datatype (Access 2000)

Topic

New Reply

Please help!!! I have been working on a database application for some months and have all but finished…just polishing up the code comments and writing the help files (ugh). For some inexplicable reason my application has decided to stop functioning! Now when I try to open any form I get the message “You canceled the previous operation” 3 or 4 times then the message “Module not found”. I have not deleted or renamed any modules.

When this happened I went to my backup copy and it was doing the same thing. I have tried creating a new database and imported all of the tables, forms, queries, reports, macros and modules…this database has a different problem…it doesn’t recognize database as a datatype! I get the message “User defined type not defined”.

The only thing that I have done this morning was to remove the multiples of backups I had created previously, leaving just the latest version (which was working perfectly before I did this) and a new backup of the current version.

Please someone have an explanation and solution to either or both problems.

Reply | Quote

Replies

In your new database, you’ll have to go into the VBE and set a reference to DAO 3.6. ADO is the default object model for Access 2000 and it doesn’t have a database object. If you’re writing DAO code exclusively, then you can turn the ADO reference off. Otherwise, you’ll have to get into the habit of specifying your declarations as DAO or ADODB to keep Access from getting confused between the two models.

Reply | Quote

Thanks for that…1 problem solved now another . I have one form that will no longer open, I get the following message “The Microsoft Jet database engine could not find the object ‘frmVolumeToWeight’. Make sure the object exists and that you spell its name and the path name correctly.” I get this message even when I select the form directly from the forms window (not just from trying to open it through code).

Reply | Quote

It sounds as if your database may also be corrupt – if you haven’t already, try a compact and repair and see what if any error messages you get. The compact and repair may not fix your problem, so you may need to re-import the form is question, or you may need to import everything into a new database once more. Hope that helps!

Reply | Quote