File Size limit

S

sbv3

Hi all!

It seems that I am getting an error message "operation
failed" whenever the file size of my access DB reaches 2 GB.
Config: Win 2000, Access 2002, file format 2002.

any ideas?
;-)
sbv3
 
D

Dave Jones

Limit of mdb file size is 2Gb hence the error message.
Do you have split front end and back end? If not, split
the DB as a first step.
Have you tried compacting the file?
If it is still close to 2Gb when compacted you may have to
split the backend into two to keep below the limit.

Dave
 
Top