[AccessD] Weird problem

Check and see if there are decimal values that MS Access is rounding 
due to the ODBC
driver.  Also, BIT data types have to be set to NOT NULL and given a 
default value.

I have seen both cause problems.

At 09:55 AM 1/11/2012, you wrote:
>Message: 12
>Date: Tue, 10 Jan 2012 22:02:29 -0500
>From: jwcolby <jwcolby at colbyconsulting.com>
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Weird problem
>Message-ID: <4F0CFBC5.7020800 at colbyconsulting.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>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

Robert L. Stewart
www.WeBeDb.com
www.DBGUIDesign.com
www.RLStewartPhotography.com