Re: Okay....

[Jim Rudnick]

<grin> you missed the SQL by 2 lines...

Above that little code snippet is the part where I go to the dbase table and load the complete table...via this code...

SQL = "SELECT * from table Visitors"

then...

rs.Open conn SQL, 2,3

AND THEN the run thru for the items I'm adding...

rs.AddNew

rs.Fields("Visitor") = visitorName

rs.Fields("VisitDate") = nDate &amp; " " &amp; nTime

rs.Fields("IP") = comeFrom

rs.Update

THIS WORKS perfectly STILL with any 3 char NAME, that exists in my security table, but NOT with any name larger than 3 chars.

Can you see, here, that the problem seems to be some kind of 'constraint' on the name field in Visitors -- that it won't accept any more than 3 chars no matter that it's a varchar at 255 chars????

This seems simple to me -- the problem that is, and while I appreciate your help, all the questions so far have been redundant. I've been asp'ing things for 5 years and I assure you my code is perfect. It runs perfectly. But not with any name bigger than 3 chars. THIS is a mySQL problem, not an asp coding problem, I assure you alll....

Could anyone else here with mySQL expertise try to get back to me with why that might be -- and yes, I've deleted the whole table, and reconstructed a brand new one that STILL will not take a name bigger than 3 chars.

Anyone?

Jim