Re: ADOX/ADO quirk when creating a primary key

From: Frank Hickman (fhickman_NOSP_at_M_noblesoft.com)
Date: 11/28/04

  • Next message: SqlJunkies User: "VB error -2147217887(80040e21)" 
    Date: Sun, 28 Nov 2004 01:35:44 -0500

    Funny, I just stepped through your code and get the expected results however
    when I run, 0 records prints...weird. 

    -- 
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.
"Rob Nicholson" <informed@community.nospam> wrote in message 
news:eRIPQLJ1EHA.4028@TK2MSFTNGP15.phx.gbl...
>> I'll try the same code in Access 2003.
>
> Yup - same result in Access 2003 using ADOX 2.7 and ADO 2.7
>
> Even tried it in VB6 just to make sure and same problem - SET COUNT(*)
> returns zero but comment out adding the primary key and it returns 10 as
> expected.
>
> Anyone else out there willing to give it a go? It's a safe (well writes
> c:\new.db) program just needs references to Microsoft Active Data Objects
> Library 2.7 and Microsoft ADO Ext. 2.7 for DDL & Security.
>
> Cheers, Rob.
>
> PS. The above 2.8 wasn't a typo - it's 2.8 on my XP and 2.7 on the Win2K 
> PC.
>
>
  • Next message: SqlJunkies User: "VB error -2147217887(80040e21)"