Access 2003 Runtime issue

J

jwm

This is a rather generic question.

I have developed an application for a local non-profit organization. It has
a function that checks a table with street names and, if the street isn't
present in the table, offers the user the ability to add it to the
database...this to reduce spelling errors.

The routine runs fine on my desktop with A2003 and the database compiles
fine with no issues. Yet, the routine crashes A2003 runtime.

The A2003 has all the necessary libraries installed in the same locations as
the development machine.

Anyone have any ideas as to where I should look?

TIA.

jwm
 
A

Allen Browne

Can you be a bit more specific about "crashes"?
Does Windows shut it down?
Does it return an error message such as "file is corrupt"?
When? At load time? After working for a while?

I use the A2002 runtime, and it does not work work with code developed in
A2003. Even though the file format is the same, the binary is incompatible.

Of course, you must use comprehensive error handling. Errors as simple as
2501 will cause the runtime to shut down if it is not handled.

Generic things that may help:
- a decompile;
- keep libraries to a minimum (possibly just 3);
- make sure Name AutoCorrect is off.
 
J

jwm

Thanks Allen...I'll try your tips. I'll have to obtain the laptop from the
charity to document the actual error message, but whatever the error is it
closes down A2003 runtime and takes the user to the desktop.

I do know that there is no "corrupt file" message, but as to what the user
actually sees, I don't know yet.

Thanks for your ideas.

jwm
 
Top