jwcolby
jwcolby at colbyconsulting.com
Tue Jan 10 21:02:29 CST 2012
I did have bit fields. I just changed those to int and updated the values to -1 from 1 for those fields that needed it. Relinked. No Joy. Just that one record has an issue. I closed / reopened Access etc. No joy. This is truly strange. I can edit the record from SQL Server but not from (my workstation) using Access. I have been doing this for many many months using other databases / FEs and have never run into this issue. I am wondering if this is truly another user on another workstation or something. The error says "This record has been changed by another user *since you started editing it*." I know that is not true. I don't have time stamp fields. I'll try that next. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 1/10/2012 6:07 PM, Jim Dettman wrote: > Make sure there is a times tamp field in the table, no bit fields, then relink after changes > > Jim > > Sent from my iPhone > > On Jan 10, 2012, at 5:49 PM, jwcolby<jwcolby at colbyconsulting.com> wrote: > >> I have a FE recently moved to SQL Server. Bound main form, bound child form. I entered a record in the main form, entered a record in the child form. Tried to modify the record in the main form and it gives an error "the data has changed" and refuses to allow me to change the data. I can change it directly in the tables in SQL Server. I cannot modify the record directly in the (linked) table in the FE. >> >> I could create the record, but not modify the record. I can modify any other record in the table, just not the one I created. >> >> No idea why not. >> >> -- >> John W. Colby >> Colby Consulting >> >> Reality is what refuses to go away >> when you do not believe in it >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >