Access 2000 Runtime Crashes

[cpaige]

Hey Everyone!

I have a problem with the Access 2000 Runtime Environment. I have developed a program in Access 2000 Professional and put it on a network drive. I then access the network drive with a computer that has only the Access 2000 runtime program. When I open the database it works great until I try and save data then it will suddenly crash for no reason. I tried placing "on error" commands in every single sub and function, but it doesn't stop it from crashing. Does anyone know what is causing this? Does anyone know how I could figure out what is causing this? Is there any problem with the Access 2000 Runtime that I should be aware of?

Thanks! Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[cmmrfrds]

One thing to check, is that you have read/write permissions in the directory on the network drive.

 

[Junior1544]

what i would do...

Figure out one spot that the app will alwas crash... then look at the code for that module...

(Perhaps putting a msgbox in every couple of lines so you can track on the pc that's not working where in the code you are)...

Then look to see what it's tring to do...

If in a run time, you try to modify the mdb at all, it'll probably crash...

Just thoughts to help you narrow the problem down...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[cpaige]

I checked the premissions and it's all good. I thought that was the problem, but my code doesn't even get to point where it's saving. I have found one problem. For some reason the Access 2000 Runtime Env. doesn't like the format function and is very picky about type conversion. To solve my problem I'm commenting out all lines of code and uncommenting one by one. Very slow ,but I'm getting results. Is it possible that I'musing a old VBA DLL?

Any more info would be great! Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[cpaige]

I did exactly that. I put a Msgbox every few line, but It crashes during the Interruption of the code, so none of the lines are executing.

Though thanks for the ideas. Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"