Question Type conversion failure, key, lock, and validation violations

[AtLarge]

Hello, I am trying to help someone long distance. Their db has tables in Share Point and one query in particular is kicking up multiple error messages. (we both have the same permissions) I ran the same db from my PC and it worked just fine.

Since I cannot duplicate it I think it is some kind of localized problem (PC or SW related)

I understand the messages for the most part but since it's not a problem for me I think the code and settings in the db are ok as is. Basically what happens is a macro is ran, a few queries update and then it performs a date stamp to the record. However, since it fails the date stamp part gets skipped. When the db is closed and opened again it works? For me it all goes through in one swoop. Can anyone give me a clue on where to start debugging this?

 

[DavidAtWork]

You'd have to start at the point where the process starts i.e. if you click a button to start this, go to the code and set a breakpoint, step through it. If it's ok as far as calling a Macro, then you'll need to run each step in the macro separately to see where it's failing
David

 

[AtLarge]

I appreciate the reply. I was reluctant to do this since it was working for me but not for them. I suppose what I can do is a screen share through communicator and then have them step through it so I can see what it's doing at the same time. Thanks!