Hello,
I have one specific database that here & there I will get this message: "Could Not Update; Currently Locked By another Session This Machine". Well, I'm the only person using this database ever. It happens (I find so far) when I'm using a query that updates the date field on a record & also updates a field noteing that the record has been moved (Notes). It doesn't do this for every record & thus I'm not finding consistency. Usually, I end up having to shut down access & then restart it - That usually works. Although that is quite the 'clunkly' way to do it & quite frankly I'm getting tired of doing that. I've looked to see if there were any files that 'lock' access still in the folder where the database is - There wasn't.
My other problem - Which I feel maybe associated with this one is...When I close down this database it still shows access running in the task manager. I wouldn't usually look in task manager, but when I try to open the database later on, it may ask for the password & then doesn't do anything. So, I have to go into task manager, shut the database down & then open it back up. I use other databases on this same machine & none of the other ones 'Hang Around' in the task manager when I close them down. There is just something specific about this one.
Since the update query will work for other records, I'm not quite understanding why this is happening. No error numbers are being shown, just that message.
Any ideas guy's? I've search in this forum & I can't quite find the answer for my specific problem.
Thanks,
---roystreet
OK...After some serious research, I have found a simple line of code on one specific form that once I removed it, it didn't keep access running in the background anymore. That sure is NICE, no...GREAT!! I didn't even need that line. I'm not sure why it caused the problem?
But I still am getting some of the records locked. I've even looked at the fields - Trying to find some type of consistency in why some of them are locked and others aren't. Unfortunately this was & still is my main problem - I have to be able to update dates on these records.
I have one specific database that here & there I will get this message: "Could Not Update; Currently Locked By another Session This Machine". Well, I'm the only person using this database ever. It happens (I find so far) when I'm using a query that updates the date field on a record & also updates a field noteing that the record has been moved (Notes). It doesn't do this for every record & thus I'm not finding consistency. Usually, I end up having to shut down access & then restart it - That usually works. Although that is quite the 'clunkly' way to do it & quite frankly I'm getting tired of doing that. I've looked to see if there were any files that 'lock' access still in the folder where the database is - There wasn't.
My other problem - Which I feel maybe associated with this one is...When I close down this database it still shows access running in the task manager. I wouldn't usually look in task manager, but when I try to open the database later on, it may ask for the password & then doesn't do anything. So, I have to go into task manager, shut the database down & then open it back up. I use other databases on this same machine & none of the other ones 'Hang Around' in the task manager when I close them down. There is just something specific about this one.
Since the update query will work for other records, I'm not quite understanding why this is happening. No error numbers are being shown, just that message.
Any ideas guy's? I've search in this forum & I can't quite find the answer for my specific problem.
Thanks,
---roystreet
OK...After some serious research, I have found a simple line of code on one specific form that once I removed it, it didn't keep access running in the background anymore. That sure is NICE, no...GREAT!! I didn't even need that line. I'm not sure why it caused the problem?
But I still am getting some of the records locked. I've even looked at the fields - Trying to find some type of consistency in why some of them are locked and others aren't. Unfortunately this was & still is my main problem - I have to be able to update dates on these records.
Last edited:
