Yes but the error is stating that and key is bound on that column there fore if you destroy that field then you will have an invalid key assigned to other records. Access is a crap database and thats why you might have gotten away with it, but SQL does a check on those fields. Its also possible you might be creating relationships with your code but the problem is key relationships defined either in the database table or the dataset table. nick I'm not an expert yet, but I play one at work. Yeah and here too.