Re: ADOX/ADO quirk when creating a primary key

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 11/27/04 

Date: Sat, 27 Nov 2004 01:50:17 GMT

Hi Rob,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that your SELECT COUNT(*) code doesn't work
properly in your VBA project. If there is any misunderstanding, please feel
free to let me know.

Yes this is a managed newsgroup.

Thanks for the code you have provided. However, with these code I cannot
reproduce this problem. On my machine, it works as expected with the
primary key set. The following is the output.

Fred 01
Fred 02
Fred 03
Fred 04
Fred 05
Fred 06
Fred 07
Fred 08
Fred 09
Fred 10
10 records

I'm currently using Access 2003. Could you let me know your version? Thanks!

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: Tactics for Debugging Custom Components with CodeDom Serialized State
    ... Hi Mark, ... call stacks? ... Based on my understanding from this reply, ... Without reproduce out this issue, I am not sure why we can not assign the ...
    (microsoft.public.dotnet.framework.windowsforms)
  • RE: Opacity
    ... I would like to confirm my understanding of your issue. ... From the MSDN, ... I can not reproduce the problem. ... Peter Huang ...
    (microsoft.public.dotnet.languages.vb)
  • RE: MSHTML PasteHTML function duplicating Tag
    ... Can you provide a little sample project to demonstrate the problem? ... be helpful to the understanding. ... to reproduce the problem. ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.dotnet.general)
  • RE: Debugging IL code in VS 2005
    ... Is it possible for you to post some detailed steps to help us reproduce out ... This will be helpful to the understanding. ... Best regards, ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.debugging)