Ok...I'll do my best to describe the situation.
I have an Access Data Project that connects to a SQL server. In my code, I deal with all the of the data with ADO Recordsets.
I have an issue with users in remote locations connecting to the SQL server over the WAN. On occassion, there forms will just lock up and they have to CTL-ALT-DELETE to get out of the program. Nobody has this problem locally in the office, it just seems to be the remote sites. I added some error trapping code one time to determine at what point the lock up was happing and it seemed to be occuring as it was trying to open the recordset.
One thing to keep in mind, is that this only happens occassionally. They will be able to add several records and then while performing the same operation, they freeze up. One user said that he will sometimes experience it right after jumping out of Access to check email in Outlook. Not sure if that's related or not.
I would appreciate any nudge in the right direction. I have been pulling my hair out on this one!
Thanks in advance for any and all suggestions/help!
Scott
I have an Access Data Project that connects to a SQL server. In my code, I deal with all the of the data with ADO Recordsets.
I have an issue with users in remote locations connecting to the SQL server over the WAN. On occassion, there forms will just lock up and they have to CTL-ALT-DELETE to get out of the program. Nobody has this problem locally in the office, it just seems to be the remote sites. I added some error trapping code one time to determine at what point the lock up was happing and it seemed to be occuring as it was trying to open the recordset.
One thing to keep in mind, is that this only happens occassionally. They will be able to add several records and then while performing the same operation, they freeze up. One user said that he will sometimes experience it right after jumping out of Access to check email in Outlook. Not sure if that's related or not.
I would appreciate any nudge in the right direction. I have been pulling my hair out on this one!
Thanks in advance for any and all suggestions/help!
Scott
