Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2002
    Location
    Scotland, Midlothian, Scotland
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Can't find Module when opened by shortcut (Access 97 SR2)

    Having a problem with a group of users. I have set a shortcut up on their desktop which points to the database file on the server. Access loads but gives the error message:

    "Microsoft Access can't find the module blahblahblahDbname.mdb"

    If I open access an then open the *.mdb file it opens and runs as expected.

    Users have create access to the directory I am using.
    The short cut works fine for me.

    Any suggestions out there
    <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Can't find Module when opened by shortcut (Access 97 SR2)

    <P ID="edit" class=small>(Edited by D Willett on 08-Nov-02 11:23. )</P>I've had a similar problem after closing my database from time to time.
    What I found was a dormant ldb file or a temp copy of the database, usually db1.
    If I delete these, all seems to be ok after.
    Not sure if this the answer to your problem, but it's worth checking anyway.
    If this is the case, it may be worth looking at the close statements within your db's.
    I've not had the problem in a good while.

    Just a thought.
    Are you using FE & BE or are the shortcuts the only source to the database.
    I put all my tables on the server and a copy of the database with forms and links only to the tables, on each pc in a root directory. There's a shortcut on each pc, pointing to the root database.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access Can't find Module when opened by shortcut (Access 97 SR2)

    I don't know what's causing this, but the workaround would be to change the shortcuts so they invoke Access directly and then include the database on the command line. Something like:
    "C:....your path...msaccess.exe" "yourservername...path...dbname.mdb"
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Lounger
    Join Date
    Jan 2002
    Location
    Scotland, Midlothian, Scotland
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Can't find Module when opened by shortcut (Access 97 SR2)

    Have checked this. We have just had PC's installed throughout and they all have the same build (allegedly). The short cut works fine on my PC but not on this group. Not seeing any orphaned files so I don't think that is it and I have checked that the correct files associations are there - there was an error but this has been fixed.

    Not use FE / BE model as I felt that I wanted to get it working in a way that I understood. Also the app is still under intensive development so it is easie for me to update this way. May shift FE/BE later.

    Thanks for the input thought

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Can't find Module when opened by shortcut (Access 97 SR2)

    How many users do you have.

    I still think with the way you have set this up, you will create problems.
    From what I see here, you have many shortcuts to the same " one database".

    When one user closes his database, its messing up with the ldb file. (some-one butt in if I'm wrong)

    setting up with FE & BE isn't a great task, Again , I should look to this option.


    Try this on ONE other pc which is causing the problem. Back up database first.
    1. Copy database to the server.
    2. Delete all items except for the tables.
    3. Put on problem pc a copy of the database and delete the tables.
    4. Use Table Link Manager and link problem User to the server database.

    From here, if the problem user you have chosen does not error any more, at least you'll know whether to proceed to the other users.

    Hope this helps

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

    Re: Access Can't find Module when opened by shortcut (Access 97 SR2)

    If everyone is opening the same database on a network drive, the first person who opens it creates the ldb file, and everyone else adds a record to the same ldb file. The last one to exit the database will also destroy the ldb file.

    In general, if you want Access databases to open correctly using a shortcut, you need to include the full path to the Access executable, which is normally going to be on the local machine, and then the full path to the location of the mdb file, with a space between the two paths. If either path contains spaces (i.e. C:Program Files etc), then you have to put that path in quotes. If you're trying to use a network shortcut, that is a shortcut that actually resides on a network drive rather than on the local machine, you have to use UNC paths or you're going to have problems.

    You'll also have problems if you have any references set in the database to libraries that may not be in the same location on all machines. Keep in mind that if a reference is set to something on C:, that doesn't mean the same thing to the server that it does to your workstation.
    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
  •