Access Database [File is open in another program]

When working with Access Database, sometimes the file (Microsoft Access) can get orphaned by a process. Now here is what gets tricky, when you open a Task Manager, the process won't show and you will not know what Process is running or preventing you from closing and Compacting the Access Database. When you see this you start to panic, here is the solution:


Solution:

Follow this link here to resolve the problemĀ