I have an Access 2003 adp using a SQL Server 2008 backend. There are approx 20 users who are located in a different state and are connnected using the company WAN. Records do not save about 30% of the time. In my efforts to research/resolve this, I have coded a save on the data entry form using the Dirty property on a combo box that is one of the first things a user uses. I have also coded the save on a command button that is one of the last things a user uses. The 1st save works fine, when there is only a litle bit of data in the form. The 2nd one fails about 30% of the time. Several of the fields typically contain about a paragragh or two of text that the user inputs (datatype is text) which are never populated with the 1st save, and always populated with the 2nd. What I end up with is an incomplete record and the user ends up having to close the form and reopen it because he can't get off the record. Any help would be GREATLY appreciated!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.