Advice needed for a growing Access 2000 project
- From: Howard Canaway <hcanaway@xxxxxxxxxxxxxxx>
- Date: Thu, 30 Aug 2007 09:48:33 -0400
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
.
- Follow-Ups:
- Re: Advice needed for a growing Access 2000 project
- From: Larry Linson
- Re: Advice needed for a growing Access 2000 project
- From: Arno R
- Re: Advice needed for a growing Access 2000 project
- Prev by Date: A2K - how to select a record, programatically on a continuous subform
- Next by Date: Re: A2K - how to select a record, programatically on a continuous subform
- Previous by thread: A2K - how to select a record, programatically on a continuous subform
- Next by thread: Re: Advice needed for a growing Access 2000 project
- Index(es):