Employee Job Administrator
Hi There
I've Been Asked For A Software That Manages Employee Where The Software Has To Assign Shifts For Employees Without Time Conflicts Or Duplicate Job For The Same Employee in One Shift
Hope I Described My Problem Clearly
Any Ideas Or Anyone Has Done This Previoulsy
Thank In Advance
View Replies !
Database Shut Down
I've created a query with a SWITCH component inside it. It
gave me the results i wanted but now if I try to see that query in Design View or run that
query, the entire database shuts down on me. So I'll have to create this query over again.
Is there any way I can avoid this in the future? Also is there any way of getting into the current
query that used to work, and fix it?
View Replies !
Record Locked & Access Wont Shut Down
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. :confused:
View Replies !
TRACKER
