Yechiel,
Access 1 had a limit of 100MB. Access 97 had a limitation of 1GB per mdb file. Newer versions are up to 2GB per mdb file. There are ways around it like compacting or splitting the database into multiple MDB files. Of course more detailed discussion should be on Access-L.....
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
I do not know if this was a configuration error or something that is built into access but some time ago a package based on access stopped working. We found out that the access database got to 1GB size and stopped growing so they could not insert new data into it.
Yechiel Adar
Mehish
