Access 2002 crashing

[Alan Brasel]

I have an Access database that I have been using for over a year. My
company just replaced my computer with a "New and Improved" computer,
and they also installed Access 2002 ( I was using 2000). The problem
that I am having is that the program crashes when it goes to run some of
the VBA code that hasn't been changed and was working for the past year.
Most of my VBA code has to do with DLookup. Is there some problem
(other than speed) with the DLookup function? The interesting part is
that it appears to crash at different places in the VBA code. In case I
haven't made myself clear, everything worked fine with old computer and
Access 2000, but I haven't gotten it to work at all with new computer
and Access 2002.

Does anyone have any ideas? Are there any preferences or options that
need to be set?

Thanks for your help

[Allen Browne]

Re: Access 2002 crashing

Suggestions:

1. References.
Open a code window. Choose References from the Tools menu. Make sure none
are marked "MISSING". Deselect any references you do not need. More info on
references:

http://allenbrowne.com/ser-38.html

2. Compile
After setting your refs, make sure the database compiles: Compile from Debug
window (in a code window).

3. Service packs
In the main Access window, choose About from the Help menu. If you do not
see:
Access 2002 SP-3
then go to support.microso ft.com and download the latest service pack for
Office 2002. While you are there, get the JET4 SP8 from the Downloads
section as well.

If those 3 do not fix it, post back for more information.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alan Brasel" <brasel@snet.ne t> wrote in message
news:4085B55D.5 020800@snet.net ...[color=blue]
> I have an Access database that I have been using for over a year. My
> company just replaced my computer with a "New and Improved" computer,
> and they also installed Access 2002 ( I was using 2000). The problem
> that I am having is that the program crashes when it goes to run some of
> the VBA code that hasn't been changed and was working for the past year.
> Most of my VBA code has to do with DLookup. Is there some problem
> (other than speed) with the DLookup function? The interesting part is
> that it appears to crash at different places in the VBA code. In case I
> haven't made myself clear, everything worked fine with old computer and
> Access 2000, but I haven't gotten it to work at all with new computer
> and Access 2002.
>
> Does anyone have any ideas? Are there any preferences or options that
> need to be set?
>
> Thanks for your help[/color]