I know virtually nothing about Access and nothing about any form of coding or programming, so please bear with me if I don't explain this exactly.
We have an inhouse software program that has been a 'work in progress' by 1 guy for 17 years, he is constantly fire fighting problems that each department here throws at him, one of these concerns my department and he cannot address the issue and is to stubborn (proud?) to try and get help. The problem is this
I have 20 drivers who were phoning in Proof of Deliveries (POD's) and thus bunging up the tranpsport phone lines, I therefore had a hidden page written onto our website which the drivers can access through their PDA's and can populate 4 fields which when sent updates our database in live time. This works well about 75% of the time but every now and then the server stalls on the update and a few days worth of POD's are held and not updated. The software guy is always moaning that it is an Access problem as the DB automatically increments by 1 every now and then, thus throwing the numbering system out of sync.
Does anybody recognise this or understand the problem so that I can point him into perhaps becoming a member here and not being so stubborn!