Re: Programatically add a constraint. ADOX?

Hi !

It now works. There were 2 problems that prevented me from seeing the light.

1) I had primary and secondary table mixed up. I needed to add the
constraint to the secondary table. I hadn't realised that, but I guess it's
logical when you think about it.

2) The Access IDE gives me a syntax error when I try to issue the correct
SQL statement. Using my own little helper application to issue the same SQL
statement via ADO works !!


.

Relevant Pages

  • Re: ADO Behaving VERY badly...
    ... > VB6 and VBScript to retrieve ADO Recordsets for a number of individual SQL ... > two second pause, and a few more statements will execute, then another ... It's not dependent on the SQL statement being issued, ... This database is pretty tight, normalized, and indexed ...
    (microsoft.public.data.ado)
  • Re: Syntax error in FROM clause
    ... It appears that the maximum length of the SQL statement has been reached. ... "George wilson" wrote in message ... >><MS ACCESS MVP> ... >>> a "Syntax error in FROM clause" and is unable to view ...
    (microsoft.public.access.forms)
  • Re: INSERT command doesnt work in Access
    ... that OleDbException, that says "Syntax error in SQL statement". ... Lately I've tried simple OleDbCommand, ...
    (microsoft.public.dotnet.framework.adonet)
  • filling a dataset with two tables using a single query
    ... Consider a SQL statement like this: ... In ADO, the following code will locate the record and if found, update both ... in two separate trips to the DB. ... Load the resultset as an untyped dataset or use a datareader. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: rewrite QBE SQL statement
    ... I am now getting a syntax error that tells me that I am missing an operator ... Is there a way to rewrite this as nested subqueries in such a way ... I am trying to write a SQL statement based on a SQL statement from the ... I am trying to rewrite this into workable SQL that I can pass as string ...
    (microsoft.public.access.modulesdaovba)