Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reference to DAO 6 (Access 2000)

    Is there any way to refer to DAO 6 in the object library on opening the form without manually going to to tools-reference-dao 6 and clicking on it ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reference to DAO 6 (Access 2000)

    Why would you want to do that?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reference to DAO 6 (Access 2000)

    because we are sending a file for updating the products list to our affiliates and we create the database to be sent by clicking the button.We de do it every day. In this case it is far more convenient to create it on the fly instead of opening the database to refer to the library.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reference to DAO 6 (Access 2000)

    There's no need to create a new database each time. You can create a blank database once, add the tables you need and set the refererence to the DAO library. Store this database in a convenient location. When you want to send an e-mail to your affiliates, you can send this database, or a copy of it.

    (It would be very difficult to set the reference in code. As soon as you run *any* code in a database that contains DAO code and that does not have a reference to the DAO library, you'll get an error message. So the code to set the reference would fail immediately.
    Although it would be possible to get around this, it is very complicated. You would have to rewrite all your DAO code, and the code would become much more difficult to maintain.)

  5. #5
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reference to DAO 6 (Access 2000)

    Thank you. I will follow your advice

Posting Permissions

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