I have a master table already in relationship with numerous 1:1 and 1:Many tables. For some reason in MS Access 2010 the autoincrement failed and I am now having the ContributorID field (AutoNumber) in tblContributor table starting new records on single digit ContributorID's which causes a problem as I already have 255 records at this point. I tried using the Alter table command but since I already have relationships set up it wouldn't allow me to do the AutoIncrement SQL command. I have been having some very weird problems with MS Access 2010 having to do with compiling. If I don't compile before closing the application and there were errors the app won't open or Opens and crashes. Any help would be appreciated. Love the book but no answer there.