Re: problem with join


"William Meyer" <meyer.wil@xxxxxxxxx> ???????/???????? ? ???????? ?????????:
news:4817394d$1@xxxxxxxxxxxxxxxxxxxxxxxxx
William Meyer wrote:

Is there a problem using the name State?

I see that in some SQL dialects State is a reserved word. Given that
the tables from which I must import arrive with that column name in
use, how can I resolve the problem in my app? Without, that is, first
opening the DB in Access to rename the column....
You have to quote like this: MA.[State]


.

Relevant Pages

  • Re: problem with join
    ... William Meyer wrote: ... I see that in some SQL dialects State is a reserved word. ... opening the DB in Access to rename the column.... ...
    (borland.public.delphi.database.ado)
  • RE: mid function
    ... 'Control' is an Access reserved word, ... Also, where are you putting this code, in a query, or in a form's event? ... Are you trying to rename a field at run time (it's impossible - in any object! ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to DSUM multiple fields
    ... Are you saying you want the sum of the four fields? ... Note that you should rename your field from Date: that's a reserved word, ...
    (microsoft.public.access.forms)
  • Re: time field
    ... Rename your control "txtTime" and try If IsNullThen ... ... "Time" is a reserved word in Access. ...
    (comp.databases.ms-access)
  • Re: Date & time
    ... In addition to the advice John gave you, I'd strongly recommend that you ... rename the field in your table named Now. ... Now is a reserved word, ...
    (microsoft.public.access.forms)