I have a VB6 application that uses a ADODB.Connection, Microsoft.Jet.OLEDB.4.0;(MS Access database .mdb). The program runs fine on my XP machine, but when I run it on a Windows 7 machine, I get errors. At first I was getrting a "invalid use of NULL" error. I fixed that by adding " to my text fields (DATA_KEY.Text = C_rs.Fields("Data_key") & "").

Ok...I get passed that error now, but now I noticed that when ever it opens the program with the default "empty" database, the Win7 machine automaticaly adds a new entry and screwas up the key. Again...the XP machine runs the software flawlessly.

What am I doing wrong? is there an issue with Win7?