I was working with Allan over in the access forum and created a DB based on one of his designs. got it mostly like I wanted and then thought I would move it to sql. I ran the upsize wizard (following a MS bulletin on using it). Seemed to go ok except that now if I add a user to my user table they show up but can't log in. and in the user screen they can not add any records.

I know it will be hard to help since you don't have the db to look at, but let me know what I can do to help. i'd really like to make this work on sql