RE: Access project vs. Access db

Hi, Brian.

> 1. This line give me an "Invalid column name 'True'" error. Why?

Because the syntax you are using is asking the database engine to compare
the value in the "Active" column with the value in the "True" column for each
record. Unless you actually had a field in your MDB database table named
"True" holding a Boolean value, the block of code below this IF statement
will never execute, because no records will ever meet the condition "Active =
True." Jet won't warn you of this logic error, but SQL Server does.

> 2. Where can I get general/ongoing help with what may be a host of these
> little syntax (?) changes when migrating from Access fe/be to Access project
> / SQL?

Download the SQL Server Books Online (BOL) on the following Web page:

http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en

As a quick reference, please see the following Web page for Jet 4.0 Reserved
words to avoid, which are ANSI SQL-92 compliant, which is used for SQL Server
2000 and MSDE:

http://support.microsoft.com/?id=321266

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are Ripley@xxxxxxxxxxxxxxx and scott@xxxxxxxxxxxxxxxxxx

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


"Brian" wrote:

> I'm just beginning to experiment with upsizing from .mdb's to SQL using the
> upsizing wizard. One specific question, one general question:
>
> 1. This line give me an "Invalid column name 'True'" error. Why? Active is
> the name of a Yes/No field that upsized OK. I can look at the table and see
> it just fine.
>
> If DCount("[UserID]", "[UserRoles]", "[UserID] = '" & [UserID] & "' and
> [Role] = 'Application' and Active = True") > 0
>
> 2. Where can I get general/ongoing help with what may be a host of these
> little syntax (?) changes when migrating from Access fe/be to Access project
> / SQL?
.

Relevant Pages

  • Re: UPDATE server_table INNER JOIN local_table
    ... Access using the query builder mechanism, the ODBC driver between Access and ... SQL Server will essentially change on the fly the syntax to conform to the ... I'm not sure if you are using a native Access database ...
    (microsoft.public.sqlserver.odbc)
  • Re: UPDATE server_table INNER JOIN local_table
    ... Access using the query builder mechanism, the ODBC driver between Access and ... SQL Server will essentially change on the fly the syntax to conform to the ... I'm not sure if you are using a native Access database ...
    (microsoft.public.sqlserver.clients)
  • Re: UPDATE server_table INNER JOIN local_table
    ... Access using the query builder mechanism, the ODBC driver between Access and ... SQL Server will essentially change on the fly the syntax to conform to the ... I'm not sure if you are using a native Access database ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Check SQL syntax
    ... Syntax depends on specific database and I do not think there is universal ... SET NOEXEC ON statement and then actual SQL statement to the server. ... NOEXEC ON option tells SQL Server just to check syntax of the query without ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Access project vs. Access db
    ... the SQL docs, but in the meantime, what is the correct syntax for Boolean ... Jet won't warn you of this logic error, but SQL Server does. ... Where can I get general/ongoing help with what may be a host of these ...
    (microsoft.public.access.modulesdaovba)
Loading