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

    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?
    Thanks

  2. #2
    Join Date
    May 2002
    Location
    Atlanta, GA
    Posts
    117
    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

    Kal

  3. #3
    Join Date
    May 2002
    Posts
    2

    Thanks! it worked

    Thnks!

Posting Permissions

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