Invalid Argument - Run Time Error 3001

[ianclegg]

My database application has now grown to over 2 Gig in size. I have approx 900,000 records in one of the tables.

Sporadically I am now getting an error message RT error 3001 - Invalid argument when trying to update the file.

Is there a maximum size to access databases or *.MDB files is it version dependant or OS dependant.

I have tried it on a Win98 machine & Win2000 machine at SP1 level.

Thanks in anticipation

Ian Clegg

 

[simongallop]

Maximum table size 1gig. Maximum recommended db size 1gig (Access97)

 

[Pat Hartman]

Time to split your data into several back end databases.