I have a massive Access frontend working with SQl Server and its crashing in a very dramatic way (typical APP CRASH discussed everywhere). Its is not happening randomly since its happen with only a few records.
Lets say I have 2 records on a user database:
UID Username Phone
1 Carl 65412
2 Sarah 45646
As you can see there's no difference in the two records in the way that in both cases the data is consistent with the field properties.
Then there's an Orders table and the crash happens when trying to add a new order for Sarah, every time, 10 out of 10. And there's no problem when trying to add orders to Carl.
I know this is not enough info but maybe someone has experienced similar scenario. If not I can send some money for help, I can send more details through email.
Lets say I have 2 records on a user database:
UID Username Phone
1 Carl 65412
2 Sarah 45646
As you can see there's no difference in the two records in the way that in both cases the data is consistent with the field properties.
Then there's an Orders table and the crash happens when trying to add a new order for Sarah, every time, 10 out of 10. And there's no problem when trying to add orders to Carl.
I know this is not enough info but maybe someone has experienced similar scenario. If not I can send some money for help, I can send more details through email.