Cannot find C:\OEL.mde

Discussion in 'Access Forms Coding' started by skydiver, Jul 2, 2012.

  1. skydiver

    skydiver Guest

    Hello all,

    I work for state government (corrections) and I have been writing
    databases for a few years. We are currently using Access 2003, with
    the intent of moving to 2010 by the end of the year.

    The set up is as follows, the database is split, with the backend
    being on the server and the frontend being located on the C:\OEL
    \OEL_ARF.mde folder of the local machine. There are many machines in
    our organization, with only one frontend in a local area of each
    machine for each user to use. Most, if not all the machines we use
    are what we called shared, in the respect that there are multiple
    users who can use each machine. Each user has a logon user ID and
    password to logon to the computer and then can use their logon
    credentials to logon to the database. Once they logoff, the next user
    can logon to use the machine. It used to be that all users would have
    Admin rights to the machine, but now everyone only has User
    permissions. I don't know if this is an issue or not.

    I also use an UploadFEVersion function to copy a new version of my
    database to the user’s machine when I upload a new version to the
    server location.

    I am having two issues here, but I am not convinced they are related
    at all.

    1.) The first issue I am having is that when the new database is
    copied to the user’s machine, the database is shut down and restarted
    via code. On occasion, when the database is shut down, after the code
    has closed and opened the database, the user will receive a message
    stating the database is corrupted and needs to be repaired or it isn't
    a database at all. The user is asked to repair the database and
    everything works just fine.

    2.) Because there are many users on these machines and every user has
    their own person space in the Documents and Setting folder, on
    occasion, when a user logs off the database and computer and the next
    user logs on, when the user tries to open the database they receive a
    message telling them that Microsoft Office cannot find the C:\OEL
    \OEL_ARF.mde. When you go to the location of the database the
    database is there but you cannot open the database and you cannot
    delete the file here. It is like there is a locking file stored in
    the previous user’s profile. Does anyone know if that is a known
    issue?

    If anyone can assist me with either of these two issues, I would be
    greatly appreciative.
     
    skydiver, Jul 2, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. joyo

    why I can't make a mde file

    joyo, Jun 28, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    68
    Andrew Backer
    Sep 27, 2004
  2. Amrou M.
    Replies:
    2
    Views:
    104
    Marshall Barton
    Jun 30, 2003
  3. Steve

    Creating MDE runs program

    Steve, Jul 21, 2003, in forum: Access Forms Coding
    Replies:
    0
    Views:
    92
    Steve
    Jul 21, 2003
  4. Vladimir

    MDE

    Vladimir, Sep 8, 2003, in forum: Access Forms Coding
    Replies:
    3
    Views:
    87
    Duane Hookom
    Sep 8, 2003
  5. Geoff

    Set and Save form screen position in MDE file

    Geoff, Sep 24, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    85
    Adrian Jansen
    Sep 24, 2003
  6. Carl Rapson

    Start another MDE from one MDE

    Carl Rapson, Mar 25, 2005, in forum: Access Forms Coding
    Replies:
    2
    Views:
    213
    Carl Rapson
    Mar 28, 2005
  7. Svein Engebretsen

    Cannot make MDE-file

    Svein Engebretsen, Aug 15, 2005, in forum: Access Forms Coding
    Replies:
    2
    Views:
    80
    Svein Engebretsen
    Aug 16, 2005
  8. B. J. Betts

    Cannot Create MDE???

    B. J. Betts, Jul 18, 2006, in forum: Access Forms Coding
    Replies:
    4
    Views:
    110
    Nikos Yannacopoulos
    Jul 19, 2006
Loading...