samonwalkabout
Registered User.
- Local time
- Today, 20:50
- Joined
- Mar 14, 2003
- Messages
- 185
I have a designed a database over the past few months and finally gone live with it. Its basically a stock control system. One user keeps managing to crash it (hang it really), on switching on the Access to the VB its giving a syntax error in the key section of code. The code basically takes the end amount of stock for this week and copys this number to the start stock of the following week. then a loop for weeks ahead.
But ... she has left for the day and im on her machine. i can not get the damn thing to error whatever i try. Im thinking therefore either.
the speed of her network connection in the normal working day (with many users) is causing the error somehow.
OR
one of the other programs she runs is pulling it down. She runs MAPS (an SQL database of some sort)
Any ideas???? I has me flummoxed as i can reproduce any errors to fix. Could network speed cause VBA code to stop working? Can other SQL systems effect Access databases?
But ... she has left for the day and im on her machine. i can not get the damn thing to error whatever i try. Im thinking therefore either.
the speed of her network connection in the normal working day (with many users) is causing the error somehow.
OR
one of the other programs she runs is pulling it down. She runs MAPS (an SQL database of some sort)
Any ideas???? I has me flummoxed as i can reproduce any errors to fix. Could network speed cause VBA code to stop working? Can other SQL systems effect Access databases?
