By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Access 2002 crashing

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.microsoft.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" <br****@snet.net> wrote in message
news:40**************@snet.net...
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.