How can I avoid the 2GB limit of Access and Windows XP
Posted on 2011-02-23
I have a split Microsoft Access database which has a backend mdb file which is growing in size every day and now 1bout 1.5GB. I believe that I heard there is a 2GB limit and am concerned that I may be getting too close to this limit.
The backend MDB file can not easily be split into separate files because I need to query it and include all records that match my criteria in a single query.
My server is Windows 2000 and the work stations are XP Professional. All workstations have Access 2000 installed and the development has always been done on an Access 2000 machine.
I suspect I will soon be forced to create a backend database on a different platform and if this is so, would like to know which platfrom to use and what I will need to convert my Access MDB file.
I am also aware that 64Bit machines have enhanced capablities and wonder whether all I need to do is buy a new computer to host the mdb file, allowing me to keep the access mdb file as-is.
I'm asking for advice what to do? I have not kept up with other database technologies.