Results 1 to 11 of 11
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Converting old Access DB

    Hi All

    I have an old DB done in (I think) Access 97, which I no longer have on my PC.

    I've tried opening it in Access 2003 and 2010 but get an error about an OnClick event (there were such events as I recall). If I open the VBE and delete OnClick events, that defeats the purpose of showing what can be done (trying to show a friend how VBA helps).

    I've tried the Convert Utilities but that doesn't seem to help.

    Any ideas on how to get this working?

    TIA

    Fred

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Fred,

    Could you please post the exact error message as OnClick events are still available in the newer versions you cited.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts
    Hi RG,

    Thks. Sure. The msg is
    ====
    The expression On Click you entered as the event property setting produced the following error: Object or class does not support the set of events.
    * The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
    * There may have been an error evaluating the function, event, or macro.
    ====

    The DB was probably done in Access 97. I haven't used this file since about early 2005. When I open the file in 2003, I get a switchboard with a few buttons on it. When I click any of the buttons, I get the above. It certainly was working at one time.

    Thks

    Fred

    Fred

  4. #4
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,396
    Thanks
    445
    Thanked 404 Times in 376 Posts
    What you need is a universal database opener, such as the following:

    http://www.softpedia.com/get/Interne...r-Editor.shtml

    I've never used this one, but it looks like it is exactly what you need.

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Fred,

    It sounds like the code the OnClick event is calling has problems rather than OnClick not being supported. This is going to be hard to debug w/o access to the file.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. #6
    WS Lounge VIP Browni's Avatar
    Join Date
    Dec 2009
    Location
    Rochdale, UK
    Posts
    1,651
    Thanks
    38
    Thanked 161 Times in 139 Posts
    Fred,

    Have you checked all external references are valid?

    Within the IDE, click tools -> references. If there are problems there they would normally show up as missing.

  7. #7
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts
    Thks RG,

    No problem - attached is the file.

    While I agree with your assessment of the problem, this file hasn't been touched in 8 years, when it was working. This DB is a monthly snapshot of a computer club's membership DB. So if this particular file is a problem, I have lots more where this one came from.

    I downloaded the universal DB opener per post #4 but haven't installed it yet. So will await to see what you find.

    Also cannot access the external references: got error msg saying "Error accessing the system registry."

    Fred
    Attached Files Attached Files

  8. #8
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Fred,

    Ok you got me stumped. I've clicked on each button of the main form and they all work perfectly in Access 2010!

    FYI here are the references I have set:
    AccessReferences.JPG

    I don't get an error until I try to Export and then the error I get is a path error which is expected since I don't have the same directory structure as you do. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  9. #9
    WS Lounge VIP Browni's Avatar
    Join Date
    Dec 2009
    Location
    Rochdale, UK
    Posts
    1,651
    Thanks
    38
    Thanked 161 Times in 139 Posts
    The application also works fine for me using Access 2010 x64.

    I'm wondering if the registry error is the cause of your problems, if you have recently installed Crystal Reports this MS KB Article may be of use.

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Quote Originally Posted by fburg View Post
    ...

    I downloaded the universal DB opener per post #4 but haven't installed it yet. ...

    Fred
    Unfortunately the universal DB opener mentioned in post 4 of this thread won't help. It simply lets you look at data in your database. It sounds like you have missing references that are causing your grief. I would suggest you copy all of the objects into a new database (in 2000 or 2002/3 MDB format), and see if that helps. Since you are using the switchboard, that should work fine in 2003.
    Wendell

  11. #11
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts
    Hi All,

    Opening the DB in 2010 worked. That's all I really needed since I wanted to show someone the various components of the DB and how Access works.

    Unfortunately for me, I have not used Access 2010 before this, so the demo was a little clumsy.

    I could copy the objects into a new DB in 2000 or 2003 format but not sure that's worth it. The demo was sufficient.

    Thanks to all.

    Fred

Posting Permissions

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