S
StillLearning
Hi guys!
I have a form with 10 DLookUp fields on it. Of course, when you change
record, you have to wait few seconds before the info shows up. I also
have a list field on my form which loads very fast when scrolling
through records. So I thought:
"Why not changing the DLookUp by Lists which would be used as a
textField because they only have one record to show"
So I did, and scrolling through records in my form became very fast!
BUT, saving my db became really really slow, around 3 minutes. So it
was to open my form, around 3-4 minutes. And worst of it, when I tried
to make a mde file, Access crashed down everytime!
I thought I had a great idea, but it turned out to be a lot worst. I
tried to replace the form by a backup I had from last week with all the
DLookUps and the saving time was short and it didn't crashed when
making a mde. So the problem is really from the changes on my form.
When I try to make a mde I have this debug message:
Application Error "The instruction at "0x30b099bb" referenced memory at
"0x0916b0aa". The memory could not be "written". I decompiled my db
but still not able to make a mde.
Does anyone could possibly know why it would do that? I'd really like
to understand.
Thanks in advance
I have a form with 10 DLookUp fields on it. Of course, when you change
record, you have to wait few seconds before the info shows up. I also
have a list field on my form which loads very fast when scrolling
through records. So I thought:
"Why not changing the DLookUp by Lists which would be used as a
textField because they only have one record to show"
So I did, and scrolling through records in my form became very fast!
BUT, saving my db became really really slow, around 3 minutes. So it
was to open my form, around 3-4 minutes. And worst of it, when I tried
to make a mde file, Access crashed down everytime!
I thought I had a great idea, but it turned out to be a lot worst. I
tried to replace the form by a backup I had from last week with all the
DLookUps and the saving time was short and it didn't crashed when
making a mde. So the problem is really from the changes on my form.
When I try to make a mde I have this debug message:
Application Error "The instruction at "0x30b099bb" referenced memory at
"0x0916b0aa". The memory could not be "written". I decompiled my db
but still not able to make a mde.
Does anyone could possibly know why it would do that? I'd really like
to understand.
Thanks in advance