>>> If your MDB was created with A97, it won't help opening it with this newer driver.
>
>well, i'm a little confused. one of the documents that you suggested for me to look at has informaton on which drivers and which Access would be able to display the autogenerated key. in that info (
http://support.microsoft.com/support/kb/articles/q244/1/36.asp) it appears that A2K with JetOLEDB or Jet ODBC 4.0 should work but it won't with A97. so can't i use A2K and convert my current 97 mdb to 2000? of course, that's assuming that i'll be able to get my jet drivers working....i re-installed mdac but it didn't do anything.....oi
>
>piper
Have you tried the ".Move 0" after calling the Update method?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com