Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sharing Access Database (Access 2000)

    A former student asked me this question. Do you have any ideas? I am attaching a word doc that he sent me with the actual problem highlighted in Yellow. Thanks for taking a look. Appreciate any input on this one, 'cause I'm no whiz with VBA, but am so interested in it, that I should be shaken real hard...hehe.
    NMPadgett

    I have an Access Database I am now trying to share with other systems
    in the Battalion, but I can't put it on a server. It has to be run from my
    desktop. Anyway, one of the computers won't run the switchboard I have
    to navigate through the database. This is the bug that it identifies as
    the problem. I don't know enough VBA to solve this problem. Maybe he
    didn't get a full install of Access, but I just don't know. I haven't had a
    problem with anyone else's systems.

    Thanks for any help you can give me.
    Attached Files Attached Files
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing Access Database (Access 2000)

    It could be a case of a Missing Reference.

    To check it, have your former student open the Switchboard form in Design View. Next open the code behind the form. Now display the References (maybe Tools | References - it's that way for Access 97). Look for the word MISSING along the left side of the window.

    If you see any that are missing, click on the reference name (not the check mark) and write down the name of the library and its location. Then, deselect the references and re-select them. (He/she may need to close the dialog box before re-selecting will work).

    If it's not Missing References, please post back.

    HTH,

    Tom

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

    Re: Sharing Access Database (Access 2000)

    This appears to be the switchboard code created when a Switchboard form is created in Access 2002. They switched the default data access method to ADO, whereas it was DAO for 97 and 2000. Most 2000 PCs run it just fine, but I've seen two that refuse to run the code and get a debug error just as you got. The only solution I've been able to come up with is to recreate the Switchboard form on an Access 2000 PC. Let us know if that is indeed the problem and you can fix it as I suggested.
    Wendell

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing Access Database (Access 2000)

    I will let you know how it goes, when I hear back from him.
    Thanks so much.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    New Lounger
    Join Date
    Jun 2002
    Location
    Camp Lejeune, NC
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing Access Database (Access 2000)

    I couldn't find any missing references. I finally got a comm tech to reinstall Office 2000 SR-1 and now it works just fine. I do greatly appreciate your help.

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing Access Database (Access 2000)

    I am glad your problem is solved. Good luck
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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