incorrect key file for table

------=_NextPart_000_0279_01C61F38.679F2370
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_027A_01C61F38.67A16D60"


------=_NextPart_001_027A_01C61F38.67A16D60
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

MySQL Version: 4.1.10

I am loading a temporary table in a MySQL database from an Access database.
The Access database has 245 records in it and when I reach record #245 I get
the error incorrect key file for table 'tblTempClasses';Try to repair it and
any records following record #243 are dropped. I'm dropping the table and
re-creating it each time and I know it has nothing to do with the data
itself because I can change the sort and the problem then appears on a
different record but it's always record #244. The table is corrupted and the
REPAIR TABLE does fix it but what is causing it to get corrupted preventing
me from loading the entire table? Here's the table structure:

CREATE TABLE `vic_showsec_com_tblTempClasses` (
`ClassSelected` enum('ON','OFF') default
NULL,
`ClassNumber` varchar(11) default NULL,

`ClassDescription` varchar(100) default
NULL,
`ShowNumber` int(11) default NULL,

`ClassPrice` decimal(5,2) default NULL,

`ShowID` bigint(20) default NULL,

`ClassDate` date default NULL,

UNIQUE KEY `ClassNumber` (`ClassNumber`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1



Vic


------=_NextPart_001_027A_01C61F38.67A16D60
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



charset=3Dus-ascii">

MySQL Version: 4.1.10

I am loading a temporary table in a =
MySQL=20
database from an Access database. The Access database has 245 records in =
it and=20
when I reach record #245 I get the error incorrect key file for table=20
'tblTempClasses';Try to repair it and any records following record #243 =
are=20
dropped. I'm dropping the table and re-creating it each time and I know =
it has=20
nothing to do with the data itself because I can change the sort and the =
problem=20
then appears on a different record but it's always record #244. The =
table is=20
corrupted and the REPAIR TABLE does fix it but what is causing it to get =

corrupted preventing me from loading the entire table?  Here's the =
table=20
structure:

CREATE TABLE =
`vic_showsec_com_tblTempClasses`=20
(  =20

           &nb=
sp;           &nbs=
p;         =20
`ClassSelected` enum('ON','OFF') default NULL, =20

           &nb=
sp;           &nbs=
p;         =20
`ClassNumber` varchar(11) default=20
NULL,        =20

           &nb=
sp;           &nbs=
p;         =20
`ClassDescription` varchar(100) default NULL,  =20

           &nb=
sp;           &nbs=
p;         =20
`ShowNumber` int(11) default=20
NULL,           &n=
bsp; =20

           &nb=
sp;           &nbs=
p;         =20
`ClassPrice` decimal(5,2) default=20
NULL,        =20

           &nb=
sp;           &nbs=
p;         =20
`ShowID` bigint(20) default=20
NULL,           &n=
bsp;  =20

           &nb=
sp;           &nbs=
p;         =20
`ClassDate` date default=20
NULL,           &n=
bsp;     =20

           &nb=
sp;           &nbs=
p;         =20
UNIQUE KEY `ClassNumber`=20
(`ClassNumber`)       =20

           &nb=
sp;           &nbs=
p;       =20
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1     =

Vic