[AccessD] Binding forms and controls directly to SQL Server

Hi Stuart,

I'm sorry I didn't post this yesterday.  From now on, I'll post everything
yesterday!  ;-)

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, March 23, 2010 4:32 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Binding forms and controls directly to SQL Server

Why didn't you post that yesterday!   I'd forgotten about the bit field
problem. 

I was working on updating  some Access applications I put together a few
years ago and 
couldn't work out why I could create new records but couldn't edit existing
ones in an app 
which hasn't been used for a few years (this is part of a 5 year election
cycle)

Took me a long time to work out that it was a new bit field that had been
added to the table 
since this particular application  was last  used.  

-- 
Stuart

On 23 Mar 2010 at 8:22, Dan Waters wrote:

> Are you using ODBC table links?  If so, then it's the same as if you were
> linking to an Access BE.  
> 
> Although you need to set the Bit (Yes/No) fields in SQL Server to not
allow
> nulls.
> 
> Dan

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com