Runtime Error 3421 when using a program that worked days ago

[robdiqulous]

Hello,
So I just started an IT support position at a company and one of the first big problems I have, I have no idea how to solve it. I have been looking and trying things for days. Here it goes...

They had this program written just for them. You put in a model number and quantity and things, then it accesses an Access database, and it will print out a page with the information on it. They only use this program from 1 computer and it is basically all that it does. Apparently one day they went to go do the same thing they always do, and when they go to print you get a Runtime Error 3421: Data type conversion error. While looking it up it looks like people have had this issue while making changes in their code and what not but I don't even have access to the source code. I don't know programming anyway. They can't remember if they have ever gotten this error code before but when they did get error codes, it would be because they wrote a letter or something instead of a number in one of the boxes. Normally they would just go into the access database and delete the mistake and it would work again. My boss said he did that this time and it is still not working.

The program and the file is on a shared drive coming from the server.

ALSO, when I go into the Access database they are using, I get an error saying that it cannot access the reference to "mail.ocx" version 1.0. When I go into the references it says it is MISSING: TTC mail control or something like that. It says the files location is C:\WINNT\system32. I guess that would be on the server and since it is coming from the shared server it recognizes the C:\ drive on the server. I am not even sure if these are related at all but I thought I would mention it. They don't know if that error was there before or not. I don't know how to fix that error either. I try to uncheck the box and see what happens but I am using Access 2007 and it says that this database was made on an older access so I can't make design changes.

Let me know if you have any more questions I have been banging my head on this for a while. I would love if someone can figure this out!
 
Thanks,
 
Rob

[Spoiler]

This maybe text in a numerical field in the database. Once entered the field is locked. You will need someone to open the DB in access and look for the fields that are numerical and see if they can find some bad data.

[Geek-9pm]

Is the PC in question running Windows XP?
What is the make and model?
If the problem is with the custom program, it is  unlikely you can fix it in a short time. Lack of documentation makes it out of reach.

[robdiqulous]

This maybe text in a numerical field in the database. Once entered the field is locked. You will need someone to open the DB in access and look for the fields that are numerical and see if they can find some bad data.

Yeah that is what they used to do. And my boss did it and it didn't work. Then we even deleted all of the data just to make sure and it still isn't working. Apparently though he used to go through and delete the bad entries and it would start working again. No luck this time even when we deleted all of the entries.

[robdiqulous]

Is the PC in question running Windows XP?
What is the make and model?
If the problem is with the custom program, it is  unlikely you can fix it in a short time. Lack of documentation makes it out of reach.

The computer we are using is a Optiplex 3020. Not too old. Not compared to these other computers. It is running windows 7 pro. Like I said, they have been using it and would delete the entries if they had this problem before, but they don't know if it is the same exact error code or not because no one really payed attention. And yes it is a custom program only we have. I guess the old IT guy wrote it for them. I have a file that is the same size as the program (which are both like 205 kb) I am not sure if that would be the source code or not. I don't have the right program to view it. There is no file extension that I can find either. There are 2 other files that are .rpt files though.

All of this is coming from the shared drive on the server. Do you think this has anything to do with the mail.ocx not being able to be found? I can't find a single thing on google about that ocx either.

Thank you for the replies so far anything helps! I am at the end of my wits with this.