I have a serious problem that I was hoping someone could help me with.
I had an old database that was far too large (12mb) so I decided to get rid of all the features I didn't want and reduced it to approx. 2mb. However now when I try and open the reports the program "hangs/crashes". The reports and the queries are the exact same as in the old version and I don't get any error messages so what's wrong? The query for the report runs fine and returns the correct information. It's just that when I try to preview the information in the report it crashes.
I have no problem upgrading the smaller database and running it under Office 2000 but when I run it under 97 it crashes?
Eventually I decided to re-write the entire "small" databse using Access 97 and guess what, same probllem again!
I think what is happening is that the small version (~2mb) is being allocated less memory when it is running but because of the amount of information the reports are required to display it's crashing. Interestingly I tried reducing the number of fields the report is supposed to display and it worked immediately. However this solution is not an option
The large version (12mb) contains identical reports with identical information and this does not have any problems, probably because it is being allocated more memory.
I've tried increasing windows virtual memory, compacting the "small" database and converting it to an MDE file but nothing seems to work. How can I allocate more memory to this "small" version of the database?
Can anyone help me, PLEASE!!! This is driving me crazy. Am I completely off the mark, or what am I doing wrong?
Any help/suggestionns would be greatly appreciated
Liam
I had an old database that was far too large (12mb) so I decided to get rid of all the features I didn't want and reduced it to approx. 2mb. However now when I try and open the reports the program "hangs/crashes". The reports and the queries are the exact same as in the old version and I don't get any error messages so what's wrong? The query for the report runs fine and returns the correct information. It's just that when I try to preview the information in the report it crashes.
I have no problem upgrading the smaller database and running it under Office 2000 but when I run it under 97 it crashes?
Eventually I decided to re-write the entire "small" databse using Access 97 and guess what, same probllem again!
I think what is happening is that the small version (~2mb) is being allocated less memory when it is running but because of the amount of information the reports are required to display it's crashing. Interestingly I tried reducing the number of fields the report is supposed to display and it worked immediately. However this solution is not an option
The large version (12mb) contains identical reports with identical information and this does not have any problems, probably because it is being allocated more memory.I've tried increasing windows virtual memory, compacting the "small" database and converting it to an MDE file but nothing seems to work. How can I allocate more memory to this "small" version of the database?
Can anyone help me, PLEASE!!! This is driving me crazy. Am I completely off the mark, or what am I doing wrong?
Any help/suggestionns would be greatly appreciated
Liam
