Advice needed for a growing Access 2000 project



Hello, I help maintain an Access 2000 front end for a rapidly growing business(our back end is Postgresql). As we grow we have concerns over the long term viability of Access 2000 to keep us going through all the growth we need.

Having read a post by one Bruce Pick about some maximums that Access 2000 has we have grown a bit more concerned than we were before, currently we have about ~800 forms and reports and Bruce lists the maximum number of objects at 1000.

My questions are:

Is this 1000 a hard limit? Do you or anyone you know run an Access 2000 DB with 3000 objects?

Would just upgrading to Access 2007 solve this or would we be trading a 1000 object limit for a 2000 object limit?

Other than migrating to .Net are there any other options available to help this along?

Thank You in advance
~Howard Canaway
.