Hello all,\n\nI work for state government (corrections) and I have been writing\ndatabases for a few years. We are currently using Access 2003, with\nthe intent of moving to 2010 by the end of the year.\n\nThe set up is as follows, the database is split, with the backend\nbeing on the server and the frontend being located on the C:\OEL\n\OEL_ARF.mde folder of the local machine. There are many machines in\nour organization, with only one frontend in a local area of each\nmachine for each user to use. Most, if not all the machines we use\nare what we called shared, in the respect that there are multiple\nusers who can use each machine. Each user has a logon user ID and\npassword to logon to the computer and then can use their logon\ncredentials to logon to the database. Once they logoff, the next user\ncan logon to use the machine. It used to be that all users would have\nAdmin rights to the machine, but now everyone only has User\npermissions. I don't know if this is an issue or not.\n\nI also use an UploadFEVersion function to copy a new version of my\ndatabase to the user’s machine when I upload a new version to the\nserver location.\n\nI am having two issues here, but I am not convinced they are related\nat all.\n\n1.) The first issue I am having is that when the new database is\ncopied to the user’s machine, the database is shut down and restarted\nvia code. On occasion, when the database is shut down, after the code\nhas closed and opened the database, the user will receive a message\nstating the database is corrupted and needs to be repaired or it isn't\na database at all. The user is asked to repair the database and\neverything works just fine.\n\n2.) Because there are many users on these machines and every user has\ntheir own person space in the Documents and Setting folder, on\noccasion, when a user logs off the database and computer and the next\nuser logs on, when the user tries to open the database they receive a\nmessage telling them that Microsoft Office cannot find the C:\OEL\n\OEL_ARF.mde. When you go to the location of the database the\ndatabase is there but you cannot open the database and you cannot\ndelete the file here. It is like there is a locking file stored in\nthe previous user’s profile. Does anyone know if that is a known\nissue?\n\nIf anyone can assist me with either of these two issues, I would be\ngreatly appreciative.