I am the database administrator for a secured, multi-user, networked Microsoft Access database. Explaining the issues I have encountered while in my current job as applied to database administration would take more space than my hosting plan will allow! My biggest hurdle is that I am a network admin for my sector, but do not have full access to the server…only my sector. Inherently, the issue then becomes when the server admins change security settings or network drive locations without letting me know. The most common issue with drive permission and security is not access to the backend, but instead modified permissions. The resulting error message is almost always “Could not use ‘Admin’: file already in use.” (more…)