473,320 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access 2002 crashing

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
1 1630
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Siobhan Perricone | last post by:
I have a user who is having a problem with an access database that I didn't build and haven't had anything to do with in the past. The database opens up to the switchboard, and she clicks through...
1
by: Alan Brasel | last post by:
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). ...
1
by: J | last post by:
Hi, Ive got 3 forms, (a subform within a subform within a form) and when I refresh the outermost form, Access closes and offers to send an error report. The forms worked fine a few weeks ago,...
2
by: Ray | last post by:
Stop me if you've heard this, but I am running Access 2002 and all of a sudden, if I design a particular form (it's been working fine for ages), Access crashes rather than open it in design view. ...
6
by: AAJ | last post by:
Hi all I have a listbox on a form. If I set its rowsource directly, and the query in the rowsourse returns no data, then the displayed listbox is empty (exactly as you would expect) ...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
5
by: aabean | last post by:
I've upgraded to IE7, and using Access 2002 SP3. I can no longer view DAPs without IE crashing. A coworker had IE7 and the same issue. He reverted back to IE6 and no problems. Has anyone...
5
by: fly_mo | last post by:
Hello All, I have an app that has been rock solid (sofar) installed using Sagekey scripts etc and is currently a 2002/3 file. However client is upgrading to 2007 (so I have setup a test machine...
1
by: aaron | last post by:
Hello folks, Has anyone ever experienced the Access 2002 runtime crashing when the "Compact on Close" option is set for an MDE file? We are currently having this problem on a number of...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.