Cripes am I confused!!!

[Jim Rudnick]

I'm migrating a simple dbase from Access to mySQL4 by trying to copy the same exact functionality in the new mySQL dbase that I had in Access.

I was able to install it fine, I now own mySQLFront as well.

I created a new dbase in mySQLFront, and 2 tables. One table called security lists a users name and their assiged password as follows...

Name = Jim
PW = tvr

and

Name = David
PW = qqq

The second table I created is to hold the list of users who log in, a simple table with 3 cols...VisitorName, VisitorIP and VisitTimeDate. All items for both tables are varchars and everything has been properly saved.

The problem I face is as follows and it makes NO SENSE to me at all!!!

IF I log in as Jim/tvr, everything works properly. I can then go to mySQLFront and check the actual lists and seee that yup, I just logged in. Later I'll create an asp page to show the logins in a table.

But as soon as I try to use David/qqq -- the asp page errors out with this message..
"...Microsoft Cursor Engine (0x80040E21). Multiple-step operation generated errors. Check each status value..."

No matter what I do, I can NOT get it to accept any number of chars for that name greater than 3. That is, if I cut the name David to Dav, it works fine.

What have I done wrong and why wont mySQL accept a name of 5 chars when the field is certainly a varchar that says it will hold up to 255 chars???

I am confused here guys...help?

Jim