Error Message

[lora]

Hi I wasn't sure which access forum to put this in! but looking for ideas...i have a pretty basic access button which runs an event to clear a table, run some queries to populate/create some tables for a report then display and print the report (in other words pretty basic stuff!). I keep getting an error message that a memory location is trying to access 0x00000000 and it can't be read...if i cancel i get into c++ and get an unhandled exception in the access dll...

This process is an exact copy of another process minus changes in the query names, i copied the button for the other process and made the changes, could this be confusing it??? The original process never crashes, every third or fourth time i click on the button for this process i get the error and it crashes access....

I'm supposed to be turning this over to a user and hate to have to write instructions which say when it crashes, because it will, just restart access and try again :-( that would be good to put on a resume!! [sig][/sig]

 

[DougP]

So leave it off your resume.
Is this on Access '97 or Access 2000?
Are users using it while you are modifing it too?
I would make a .MDE for them.

See My FAQ's on that:

How do I make an .MDE file
faq181-90

What is an .MDE and why do I need it
faq181-91

Otherwise you can import anything with out VBA code in it.
Tables, queries, macros,
forms, Reports and Modules may not come over.
fixing a corrupted database is no picnic and it takes a slow methodical effort to find out why.

You are not the first person to have these problems.
[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]

 

[lora]

I'm using access 97, and now it appears that my other forms are crashing the app, appears to be the print process as i even crashed trying to reprint my code...

I hadn't put this on the network yet so it was/is just me creating testing when the issue started

So are you saying my whole database is corrupt and I need to recreate?

Thanks

Lora [sig][/sig]

 

[lora]

FYI if anyone has this happen to them...I think i solved this. I kept crashing on my print statement, every third or 4th time i requested it...I did not include the acNormal, eg, DoCmd.OpenReport &quot;rptCBSVoucher-111&quot;, acNormal, at the end of my statement as acNormal is the default; well, now that i've added that code, I'm not crashing any more...a possible lesson learned for those of us who can be lazy typists and let the system use defaults? glad it worked for me at any rate. [sig][/sig]

 

[lora]

whoops, asViewNormal... [sig][/sig]