[Sorry, but this will be a lengthy intro post, but I'm in the dark big-time here]

What is the correct way to share a DB file on a networked (mapped) drive so that data entered by one user is viewable and searchable by other users?



I currently have a very old DB in place for two of the city's codes enforcement officers to enter and track codes violations. There are several old and duplicated tables and forms inside the DB that, to the best of my knowledge, are not used. There is only one form that data is entered into. For some reason, there is a linked Excel spreadsheet that generates the code violation#s and the officers manually enter that number into the DB form. There are realtionships on several of the forms, but none of those are the main form they use.

The problem is that when one user enters information, the other user cannot find the entry. For example: User A enters a new ticket #5050, after the user enters the data and saves the changes, and closes the file, User B cannot search and find the ticket previously entered, and vice-versa. The file is a shared file and they both access it from the same domain. I am a novice Access user and have had to learn my way around over the past several weeks with my new job. I did not create the DB and I don't want to modify anything I'm not familiar with. Any guidance on where to start in tracking down the problem would be most appreciated!