Access Form Null Checking with Linked SQL / ODBC Table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rich (tdmailbox_at_yahoo.com)
Date: 10/04/04 

Date: 3 Oct 2004 19:31:42 -0700

I have a access form that is connected to linked sql table via odbc.
I have some fields that I dont want to allow nulls when data is
entered via the form. I can set the null checking on the SQL server
database but the ODBC error tha tis returned is not very polite to the
user since it mentions the sql field not the nice label.

Is there a way for me to modify this error or put the check in access?

Relevant Pages

  • Access Form Null Checking with Linked SQL / ODBC Table
    ... I have a access form that is connected to linked sql table via odbc. ... database but the ODBC error tha tis returned is not very polite to the ...
    (microsoft.public.access.formscoding)
  • Re: Sybase Source. What "data flow source" to use?
    ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL using C
    ... I am almost a new C programmer and now I need to use SQL within my C ... The people who are telling you to use a C API are out of their mind. ... is not less complicated than ODBC and ties the user to a single ...
    (comp.lang.c)
  • Re: Quick primer on Unidata-to-SQL Server Connectivity?
    ... but creating a view and then running an SQL query with more than one ... but somewhat extensive experience with UniData SQL. ... until some things improved in UniData ODBC. ...
    (comp.databases.pick)
  • Re: Sybase Source. What "data flow source" to use?
    ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
    (microsoft.public.sqlserver.dts)