I have an MS Access table with an ID field set to AutoNumber - Long Integer. Even with this field setting the table will not accept records once the ID field reaches 32777. That seem to be the maximum value the table will accept. Does anyone know how to fix this problem since I have many tables with the same setting and could have many more records than 32777. It seems to imply field type Integer but the field type is set to Long Integer.