Recent content by thomas.dickens

Your guess is as good (or better) than mine... This didn't seem to be an issue for the first ~3 months of usage, and I am sure that the users' habits were just as bad back then as they are now!

Thing is it is worse than preventing routine maintenance work - it puts the BE into read only mode and no users can edit any data whatsoever. One user being careless can halt the entire team! Thanks for the advice - will look into migrating to s

I need to protect the database from poor user behaviour - specifically, users the close their laptops without safely closing the database. I know that training is a strong defence but some of the users have low IT literacy and seem to continually do this despite training. The additional problem...

Regarding this issue with users being able to lock the database just by closing their laptops without closing the database safely - I have two possible suggestions, and I wonder whether anyone could comment on the likelihood of them working: 1. Add VBA code to close the database after a certain...

Thanks all for your responses. Sorry for the delay in getting back to you - I have been out of the country and away from my computer. I believe I have been able to narrow down the cause to users closing their laptops/moving rooms without closing the database safely, RATHER than the database...

Thanks - I have checked and all users have the same permissions, including modify. Firstly, thank you for the response! I create an ACCDE file from the central front end file. Until recently, I would then ask users to copy and paste that file onto their desktops. I have since moved back to...

Thanks GPGeorge. Will definitely have a think about further training and encouraging good practice. I cannot say for sure that it is just user discipline. It seems just as likely that unexpected crashes are causing this. Can I just check something - in the majority of cases where this has...

Hi The Doc Man Thanks for the thorough response. It has been hard to pinpoint the exact catalyst each time it has occurred, but it is at least reassuring to know that this sort of thing can occur either when the front end crashes, or when a user leaves the database open whilst logging...

Hi arnelgp Thanks for getting back to me. I believe all users are in the same permission group and have: modify, read & execute, read and write. 'full control' will not be provided by our IT team because they reserve that sort of permission for themselves, but by understanding is that the above...

Hi there New to the forum. I am by no means a programmer, but I have built a couple of databases for my work and have a reasonable grip on the fundamentals. Most of it is self taught though, meaning I could easily have some bad habits. I am having a massive issue with a database that I have...