Re: Problem linking to SQL tables in Access

If you can't see the problem with the table or field names, look
also at the index names. Index names may also "include invalid
characters or punctuation [or be] too long"

(david)

"crm4094" <crm4094@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FAB8519D-3BAA-4BA9-9C5C-7A972C3BEC11@xxxxxxxxxxxxxxxx
Weird problem linking to SQL tables - if I create a project and connect to
the DB I can access tables fine - if I create Access DB & link to tables
with
ODBC connection when I try to link to tables I get an error 3125 stating
that
the primary key fields are not following standard naming conventions.
The SQL database is from our billing system - NDCLytec 2006


.

Relevant Pages

  • Query Issue
    ... "Query1 is not a valid name. ... Make sure that it does not include invalid ... characters or punctuation and that it is not too long." ...
    (microsoft.public.access.queries)
  • Re: Languages which syntax use minimal punctuation?
    ... What languages use very few punctuation characters in their syntax? ... Anyway, you actually said not that it was harder to "write a parser", ...
    (comp.programming)
  • RE: Post Code UK Structure Verification
    ... Dim invalid As Boolean ... ' Validate inner code ..... ... Notepad is used because copying from ... Sort to bring to the top records with too many characters ...
    (microsoft.public.excel.programming)
  • Re: [PHP] One last try at this!
    ... Jim Lucas wrote: ... "Invalid Characters" So $result now contains the value 'Invalid Characters'. ... At one point he mentioned changing ValidateString() to return false on an error. ...
    (php.general)
  • Re: trouble joining exchange 5.5 domain
    ... There might be some old data in AD that references the invalid domain name. ... A SKCC might be required. ... > message when trying to add an exchange 2000 server to the ... > greater than 64 characters or contains at least one of the ...
    (microsoft.public.exchange.misc)