i need to occasionally have exclusive to a shared backend file (for routine maintenance ..compact / repair, etc.)
to do this, I...
create a copy of the backend file (filename_TEMP.accd)
then refresh all of the linked tables to it, which i thought would free the original file (filename.accdb)
however, when I check if I can get exclusive access to it, I cannot. And indeed when I check the folder, filename.laccdb (from the initially linked file) is still there.
what gives?
I've checked... no one else has the file open, I have no other instances of ACCESS open that might be using it, I've put a timer in to give pause for the system to clear out the old *.laacdb file...
I'm baffled and will be very thankful for any thoughts, direction, or advice.
Mark