I set up some code to append a field to a table in a different .mdb file (opened up a new workspace, etc.). It worked the first few times, but now, after a corrupt compact/repair of the other file that has the table, I'm no longer allowed to do this from the file with the code. It keeps saying that someone else (or another process) is trying to access the file, when that's clearly untrue. I can change any other table in that database the one I need.
I've compacted/repaired both databases. My db keeps thinking that some other process is trying to access the table, no matter how many different copies of the back end (with the table) I try to open and change. I've isolated to problem to being on the Front End, but that's as far as I could go... any suggestions? Is there some sort of record locking buffer I can flush or something?
Thanks in advance,
-n-
I've compacted/repaired both databases. My db keeps thinking that some other process is trying to access the table, no matter how many different copies of the back end (with the table) I try to open and change. I've isolated to problem to being on the Front End, but that's as far as I could go... any suggestions? Is there some sort of record locking buffer I can flush or something?
Thanks in advance,
-n-