Thanks Anthony, It's mostly working !
I ran web2py from the shell (for the first time) and I was able to successfully add a row. I did forget to do a commit. Thanks for the tip. print db._lastsql also works. Sounds like I shouldn't bother with the shell in the admin screen. The appadmin database administration screen briefly flashes for a split second when I press Submit, but nothing else. Still no errors in the "errors" screen? The log has the following: 127.0.0.1, 2011-08-02 09:51:31, GET, /Max/appadmin/insert/db/ web2pytest_leg, HTTP/1.1, 200, 0.031000 Andrew

