Error in prog when it hits rs([field name]).value: Write Violation

[XJ900]

I have a program that is supposed to access a ms access database, pull the information, and then post it to a MSOWC spreadsheet.

If I run the code from VB6 it works fine, but when I compile it it crashes with an "unhandled exception...Access violation writing location..."

When I debug the program it looks like the error is happening when it tries print the recordsource (rs) with the .value command at the end (rs("[field name]").value). If I kick .value out of the code it gets hung up on the next .value line. Can anyone tell me why it does this in the .exe and how to fix it or work around it?

Thanks

 

[XJ900]

Looking at it again, I think it crashes every time it tries to look up a field in the record source.

 

[BobRodes]

hmm.

Recordsource = property that defines where a record is coming from in an ADO Data Control. I assume you mean recordset.

I would take the error message literally. You imply that the error occurs when you attempt to read something, and that's not what it says. What are you trying to write, and where? Identify that, and you'll be on the way to fixing your problem.

HTH

Bob