Hi Sir,

I found it and replace my type to Integer(AutoInc). However, after I inserted the info, it puts 1 on userid instead of 8. Please help.

OPEN DATABASE testdata
SELECT 0
USE testusers		
INSERT INTO testusers(username, userfullname) ;
VALUES(lcUserName, lcFullName)

Thanks,
Sam