Advice needed for a growing Access 2000 project

[Howard Canaway]

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

[Arno R]

"Howard Canaway" <hc******@oriskanymfg.comschreef in bericht news:xf******************************@telcove.net. ..

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

Look at Access specifications in Help. Max number of objects =32.768
So don't worry.... or ...

I highly doubt if you are using Access 'properly'.
800 forms and reports is quite a lot allready.
IF you are thinking to go to 1000 in a short term, I dare to wonder what you are doing with (or to) the database.

My 'biggest' app has about 120 tables, 130 forms and about 110 reports. Also 400+ query's.
This is a big application!

Arno R