S
SJ
Hi all,
We have a large front end that comprises
700 forms
125 reports low, because most are crystal now
140 queries
10 macros
36 modules
150 ODBC linked tables
back end is SQL server
That means there are over 1000 objects.
We started out in Access 97, we used Access 2k for a while but we hit a
limit there because Access 2k will not support that many vba modules (a
documented limit). So we started using Access XP.
Now to my question,, Quite often when using AccXP, i'm noticing that it
takes a long time to save a form and sometimes there is problems with
saving, such as the code dissapearing etc...
Does anybody out there have any experience with a front end this size????
Are there "practical" working limits.???
Occasionally it gets so slow to load that we have to create a new DB and
import all the objects, then its really fast again.
I've recently turned Name Auto Correct off.
But I think this large size is a problem. You can imagine the importance
of this question, as there would be a lot of work to move away from access.
Thanks, in advance.
Sean
We have a large front end that comprises
700 forms
125 reports low, because most are crystal now
140 queries
10 macros
36 modules
150 ODBC linked tables
back end is SQL server
That means there are over 1000 objects.
We started out in Access 97, we used Access 2k for a while but we hit a
limit there because Access 2k will not support that many vba modules (a
documented limit). So we started using Access XP.
Now to my question,, Quite often when using AccXP, i'm noticing that it
takes a long time to save a form and sometimes there is problems with
saving, such as the code dissapearing etc...
Does anybody out there have any experience with a front end this size????
Are there "practical" working limits.???
Occasionally it gets so slow to load that we have to create a new DB and
import all the objects, then its really fast again.
I've recently turned Name Auto Correct off.
But I think this large size is a problem. You can imagine the importance
of this question, as there would be a lot of work to move away from access.
Thanks, in advance.
Sean