Re: But..

[Nick Roper]

Jim,

You included the code that prepares and sends that statement:

-----------------------------------------------------------

' write new visitor to dbase to record this visit...

rs.AddNew

rs.Fields("Visitor") = visitorName

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

rs.Fields("IP") = comeFrom

rs.Update

-----------------------------------------------------------

but can you give example of the actual SQL strings that are sent to MySQL when rs.Update is called for a 3 letter or 5 letter name. For example:

"INSERT INTO visitors etc.....;"

Presumably the string is stored in a variable somewhere as it is being prepared, and then passed to the update process.

In your last message you talk about adding the name/pw/IP - but there is no password field in the table that stores the IP address.

As I say, I took your table definition and created the table and was then able to add the name OK. Have you tried updating the tables manually via the mysql client. Then you will know whether it is a problem with MySQL or with the interface.

We can't really go much further until we get a feel for what the SQL statements actually look like...

Cheers,

Nick



--
Nick Roper