Tag Archives: access

The Ten Commandments of Access

Microsfot Access 2007 LogoAnd it came to pass that the cries and lamentations of the Access newbies were heard on high by the gods of the Database, and their hearts were moved to pity for their followers. And they opened their mouths and spake, saying: “Nevermore shall the young and innocent wander witless on their journeys! We shall provide guidance to them, yea, and to all who wish to seek the paths of wisdom.” And they caused these commandments to be written and placed before the eyes of those seeking enlightenment. Continue reading

MS Access Error Message: “Could not use ‘Admin’: file already in use.”

ErrorI 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.” Continue reading