Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Albuquerque, New Mexico, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    W2K Can't Find Access 2000 Database File

    We use Windows 2000 Professional with Office 2000 on our networked PCs. I have an Access database that uses visual basic code which is ultimately saved as an .mde file (EETTCode.mde). This mde file is the front-end (on each PC) and actually stores the data in the backend database on a server.

    So, what's my problem you ask? If more than one person uses the SAME PC, Windows seems create a special file relationship with the person logged on. Even though the folder and mde file on the C: drive have the same access rights for everyone, the next user of the same PC gets the following message: "Microsoft Access can't find the database file 'C:TempoEETTCode.mde.' When you browse to locate C:TempoEETTCode.mde, you can point to the C:TempoEETTCode.mde file and then use it! It's the same file but the second user has to establish some sort of rights to it. See attached file for screen shots. Then when the first person logs back on (or a third user) and tries to use the file, they get the message that the database file can't be found (as did the second user) and they have to browse to find the file. It's like a vicious loop. Yes, they can use the file but it takes too many extra steps to do so.

    Most of my users have their own PCs and so this hasn't been too big of a headache for them. Unfortunately, four users share three PCs and it's driving them nuts. I tested other PCs and it happens on the other PCs if a different user logs on.

    I really don't think this is an Access problem but a Windows 2000 problem. I'm wondering what security setting could cause this and what can be done to fix it. I'm going to have more staff using the file and this will become a bigger problem.

    Any ideas? <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> (Note: Unfortunately, my skill level in Windows 2000 is more of a user than an administrator but I can get our IT staff to make the fix if I find one!)
    Attached Files Attached Files

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: W2K Can't Find Access 2000 Database File

    To rule out a problem with file associations, try creating a shortcut with a full command line, like this:

    "C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" /NOSTARTUP "C:TempoEETTCode.mde"

    (This is based on what I have in Windows 2000 with Office 2000 SR-1)

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Albuquerque, New Mexico, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: W2K Can't Find Access 2000 Database File

    Actually our current desktop shortcut uses that code. Just to be sure, though, I copied your code and pasted it into the cmd line (from run). We get the same message that Microsoft Access can't find the database file. I even tried creating a new desktop shortcut with the pasted code as the target and got the same message. In fact one of my tries to solve this problem, I created a new shortcut from the desktop, used browse to locate the file. I then clicked on the new shortcut and got a message from windows saying that the target was no longer correct and I allowed it to fix it. (See new attached file.)

    I know there has to be something about the way Windows 2000 was setup at the Albuquerque VA since users at other VA sites don't have this problem. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

    I appreciate the assistance!
    Attached Files Attached Files

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

    Re: W2K Can't Find Access 2000 Database File

    This is puzzling. We don't normally have multiple users on a PC, but I have roving capability setup on the network, and I can go to other user's PCs and use their shortcuts to make things happen Ok. By chance are you using Access security? I've seen weird things happen if you don't include the application path (msaccess.exe) in the shortcut if you are using the /wrkgrp command line option. I'm afraid that's the only suggestion I can make right now. Hope it helps, or at least triggers other ideas.
    Wendell

  5. #5
    Silver Lounger
    Join Date
    Apr 2001
    Location
    New York, New York, USA
    Posts
    2,328
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: W2K Can't Find Access 2000 Database File

    Suggestion:
    create individual copies of EETTCode.mde for each user and put them, for example, to Cocuments and Settings< username >Application DataMicrosoftAccess folder. Then create shortcuts on each user's Desktop (c:docu~1< username >desktop) pointing to this mde files.

    Maybe it will work?

Posting Permissions

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