Movian
08-02-2017, 05:05 AM
Hey,
so I find the need to change the Open_form event on all forms in the system from Private to Public (at least I need to do this for 75% of forms)
so rather than go through each of our forms (a couple hundred) I thought I could just do a nice find and replace
Find
Private Sub Form_Open(Cancel As Integer)
Replace with
Public Sub Form_Open(Cancel As Integer)
Set to entire project and then replace all.
The problem is access appears to start this process then complains it doesn't have enough memory to complete the task and crashes. (Access 2010)
I don't believe the DB is corrupted and it is entirely possible that as a 32 bit application it doesn't have enough memory for this...
I tried setting the large address aware flag for the executable this removed the warning message but access still crashed at the same point.....
Any suggestions for this? Perhaps I could export all the forms as text and then do some kind of batch process then import them all?
Anyone else run into this issue?
Thanks in advance!
so I find the need to change the Open_form event on all forms in the system from Private to Public (at least I need to do this for 75% of forms)
so rather than go through each of our forms (a couple hundred) I thought I could just do a nice find and replace
Find
Private Sub Form_Open(Cancel As Integer)
Replace with
Public Sub Form_Open(Cancel As Integer)
Set to entire project and then replace all.
The problem is access appears to start this process then complains it doesn't have enough memory to complete the task and crashes. (Access 2010)
I don't believe the DB is corrupted and it is entirely possible that as a 32 bit application it doesn't have enough memory for this...
I tried setting the large address aware flag for the executable this removed the warning message but access still crashed at the same point.....
Any suggestions for this? Perhaps I could export all the forms as text and then do some kind of batch process then import them all?
Anyone else run into this issue?
Thanks in advance!