Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    database not recognised as datatype (Access 2000)

    Please help!!! <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> 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. <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>
    Cheryl =^..^=

    IS Support, Adelaide <img src=/S/granny.gif border=0 alt=granny width=20 height=20>

    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: database not recognised as datatype (Access 2000)

    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.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: database not recognised as datatype (Access 2000)

    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). <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>
    Cheryl =^..^=

    IS Support, Adelaide <img src=/S/granny.gif border=0 alt=granny width=20 height=20>

    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: database not recognised as datatype (Access 2000)

    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!
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •