Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8

    Unanswered: get this ERROR HELP PLEASE !!!

    Complie Error
    Function of interface marked as restricted, or the function uses an Automation type not supported in Visual Basic

    click help
    "Function marked as restricted or uses a type not supported in Visual Basic"

    Set dbs = CurrentDb() <= Stop here


    it stop in switch board menu
    Sub FillOptions event

    Computer is XP p ( not home)

    MSaccess 97 did unstall / reinstall

    Went the References got nothing MISSING
    but only have tick
    Visiual Basic For Applications
    Microsoft Access 8.0 .....
    Microsoft DAO 3.6 Object Library

    Whats next
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    First Time Ever had this Error

    H E L P
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    looks tragic!

    foolish question: have you got a
    dim dbs as database
    also try as DAO.database just to shake things up a bit.

    foolish suggestion: try dropping the ()

    assuming you are still stuck, the error is probably not in the line you are stopping at. try commenting out the dbs and rst bits and compiling to see if you can find an error elsewhere.

    assuming you are still stuck: import all the objects into a new db

    ...after that: worry!

    izy
    currently using SS 2008R2

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Its a Networks Program
    Works ok on every other computer
    but this one.

    yes I have the Dim DB as Database
    Last edited by myle; 05-03-04 at 20:16.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  5. #5
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404
    Try checking the references under Tools. Make sure you've got something like Microsoft DAO 3.6 selected. Even if you have and you have Microsoft ADO ticked and Higher in the list it's going to affect the performance of the DAO objects. If that is the case Deselect ADO and select DAO so that it's higher, you might want to reselect ADO so that it's lower in the list than DAO.

    Hope that makes some sort of sense!

  6. #6
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    fix it

    had to created a small VB program that reinstalled the DAO files

    Thanks all for the help
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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