Re: ADOX/ADO quirk when creating a primary key

From: Rob Nicholson (informed_at_community.nospam)
Date: 11/27/04 

Date: Sat, 27 Nov 2004 15:07:22 -0000

> 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.

Relevant Pages

  • Re: Interesting date
    ... what that command was though... ... VB6 allowed you to put the "Option Base 1" directive at the top of a ...
    (comp.lang.php)
  • Re: Adding DateTime columns
    ... your time section is probably coming from a VB6 application and the date ... the zero ) so you get two days negative ... offset -- but this is just a possible explanation :-)) ... HTH, ...
    (microsoft.public.sqlserver.programming)