Jim Dettman
jimdettman at verizon.net
Wed Jan 11 07:48:38 CST 2012
Tina, It's just a data type in SQL. You do nothing with the field other then add it to the table. There are a couple of MSKB articles that fill in the detail: Optimizing Microsoft Office Access Applications Linked to SQL Server http://msdn.microsoft.com/en-us/library/bb188204(v=SQL.90).aspx Look in the section "Understanding and Addressing Updatability Issues" and then "Supporting Concurrency Checks" within that. This one goes a little bit into the keyset model that JET uses to maintain record sets and why issues arise with ODBC data sources: PRB: Explaining "Record is deleted" error accessing ODBC table http://support.microsoft.com/kb/172339 Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris Fields Sent: Wednesday, January 11, 2012 07:59 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Weird problem Jumping in here, not because I have much to offer, but because I have much to learn. Please discuss the time stamp field. How should one be made? How should one be used? Thank you for sharing your knowledge. T Tina Norris Fields tinanfields at torchlake.com 231-322-2787 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com