[AccessD] Weird problem

Something that I tend to foget until a weird issue shows up, is making
sure any bit fields in my SQL table have a default value.  When linking
to an Access front end I get strange problems (like this) if any bit
fields values are null.

Rusty

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, January 10, 2012 4:49 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Weird problem

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
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************