Chris. You might have to create an OLE link to the Access db and use the Tabledefs property to change it. Failing that, you can do it via SQL too....mmm..not sure how, I have dont it before, but I cant remember how. The access Help is quite good on how to do this. Jeremy Coulter --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz