Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002

    Exclamation Unanswered: "database" data type not available in Dim statement popup help

    In Access 2000, When declaring a variable when I say:
    Dim myDb as ..., a list pops up which should have Database listed as one of the types so that I can refer to Database objects.
    Well in my database it doesn't!

    But if I start the database wizard from New, choose one of the templates to create a dtabase, and then try it, it works.

    But if I start from a New blank database, and build it from scratch then it doesn't work.

    Can anyone help?

  2. #2
    Join Date
    May 2002
    Atlanta, GA
    Try this,

    While in you VB Window, look at your menu bar and choose the menu labeled Tools. Then choose References. Scroll down and find a library called Microsoft DAO 3.6 Object Library and place a check mark beside it. Restart access to make sure the reference is loaded (just in case).

    Hope this helps


  3. #3
    Join Date
    May 2002

    Thanks! it worked


Posting Permissions

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