rudeboymcc
Registered User.
- Local time
- Yesterday, 16:22
- Joined
- Sep 9, 2008
- Messages
- 69
Hi, I'm using a Access 2007 front end with a sql express server backend on a windows server machine.
I have a form with a sql table as a datasource. I've got a problem where if i edit an existing record (doesn't matter whcih field), when i go to close the form it hangs for around 5 minutes, and then closes without saving any changes.
Problem is fixed if i close and reopn the front end, and then will happen again later on. However i know it's not a change i've made in the front end becuase my backups (which used to work fine) also have this problem.
I've made a button that closes the form capturing any errors and there aren't any that access can capture.
so how can i see what the sql server is doing to cause the form to hang??
I have a form with a sql table as a datasource. I've got a problem where if i edit an existing record (doesn't matter whcih field), when i go to close the form it hangs for around 5 minutes, and then closes without saving any changes.
Problem is fixed if i close and reopn the front end, and then will happen again later on. However i know it's not a change i've made in the front end becuase my backups (which used to work fine) also have this problem.
I've made a button that closes the form capturing any errors and there aren't any that access can capture.
so how can i see what the sql server is doing to cause the form to hang??
