Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ActiveX problem/new user (Access 2000)

    I am a new user to Access (no problems using other MS applications) and trying to take an Access class over the Web. I downloaded files from my textbook publisher's Web site. I can open the files but when I attempt to access a database file from my hard drive (from within the Access program) I get the error message: "Active X can't create object". I am an older grey haired user [img]/forums/images/smilies/smile.gif[/img] and need someone to explain how to fix this. I did check and found that the database is or has been converted to the current release. (Whatever that really means?!?) Since it is Sunday help is not available from my school but I need to start some assignments. Takes us old folks longer to do things lol. Appreciate any help!

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

    Re: ActiveX problem/new user (Access 2000)

    What do you mean when you say "I can open the files"?
    One possibility is that the files from your textbook publisher may have been Access 97 files, and your Access 2000 converted them. In doing so, you may need to change the references in Visual Basic. To do that, open any Access module in design mode (hold down the SHIFT key when you open the database so that code doesn't run and you can see the database container window), and choose the Tools / References menu in the Visual Basic editor. If you have references that show MISSING then that is one source of this error message - and the simplest to fix.
    There are a number of other possibilities - you can read about them in <!mskb=319841>Microsoft Knowledge Base Article 319841<!/mskb>.
    Don't worry about the grey haired part - many of us are older folks, some of us could qualify for Social Security soon!
    Wendell

  3. #3
    New Lounger
    Join Date
    Jun 2003
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ActiveX problem/new user (Access 2000)

    I can open the database and it shows all the objects - but when I try to use the wizard to create a table, report, or query the error message appears. I can manually create the tbls, repts etc,. I don't understand why the wizards will not run. I read the MS Know. base article and still am at sea.

    I checked the version for the publisher and it is 2002. I am running or rather attempting to run MSOfficePro2000. The publisher also bundled Access with the other MS applications under Office XP - I had no problems using the other apps with my Win98OS but Access doesn't seem to work right under the 2000 version of Office.

    I also checked the codes - most were unchecked but it seemed that the primary references were checked - not sure which ones should be checked.

    I am really totally confused now [img]/forums/images/smilies/smile.gif[/img]

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

    Re: ActiveX problem/new user (Access 2000)

    Have you tried the various steps in the MSKB article mentioned by Wendell? In particular, those under Cause 1 (reregister DAO 3.6) and Cause 5 (rename Acwzmain.mde, Acwztool.mde and Acwzlib.mde to have extension .old, then select Help | Detect and Repair)

    BTW, the minimum references in Access 2000 are Visual Basic for Applications and Microsoft Access 9,0 Object Library. For many purposes, you also need Microsoft ActiveX Data Objects 2.n Library (n can vary) and/or Microsoft DAO 3.6 Object Library.

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

    Re: ActiveX problem/new user (Access 2000)

    Be sure and check your situation per Hans' instructions, but I am puzzled by your statement
    <hr>I checked the version for the publisher and it is 2002.<hr>
    That sounds like you may be trying to run Access 2002 format databases with Access 2000. If that's the case, it won't work. You need examples that were designed in either Access 2000 or 97 for it to be happy.
    Wendell

  6. #6
    New Lounger
    Join Date
    Jun 2003
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ActiveX problem/new user (Access 2000)

    I really think that is my problem - even though the site says that you can use 2000 with the files I don't think they are all compatible. Guess I'll have to buy Office XP - with Office 2003 due to come out soon I was trying to wait until MS offered 2 for 1 lol. Thanks for all your help!

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

    Re: ActiveX problem/new user (Access 2000)

    I wouldn't rush out and buy XP at this point - you can do some testing to determine if that really is the problem. For one thing, if you can create databases on your own using the wizards that come with Access 2000 then that says nothing is wrong with your Access 2000 install. I presume you are getting your error with several examples and not just one?

    I should think a site doing training on Access would know enough to make sure that databases created with XP need to be saved in 2000 format, and not 2002 format, so it could still be a references problem. They may be referencing ADO 2.5 or higher, and with 2000 you only have ADO 2.1. I presume they have a contact point for questions and problems - I would try bouncing your error off them.

    Based on the user name you chose, can we assume you are a baseball fan? <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>
    Wendell

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

    Re: ActiveX problem/new user (Access 2000)

    If they created the database in 2002 and saved it to 2000 format, you should be able to open and use the database in 2000. That does NOT necessarily mean you can use the 2000 wizards on it. There are some problems with creating a database in 2002 for use by 2000. Did the publisher include a runtime version of Access 2002 or were you led to believe you could use 2000 for this?
    Charlotte

Posting Permissions

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