DAO 3.5.1 - Why does my application go in la la land on this command

[MarcelBeals]

Set rsAudit = conODBC.OpenRecordset(strSQL, dbOpenSnapshot)<br><br>My application goes through this line of code once but when there is any type of D/B activity such as update or delete then the application goes into la la land on this statement.<br><br>Can anyone help?&nbsp;&nbsp;I am looking for suggestions only but will accept a better way of doing this also.<br><br>Thanks<br><br>Marcel.<br><A HREF="mailto:beals@ocas.on.ca">beals@ocas.on.ca</A>

 

[Karl Blessing]

I naturally would recomend you use ADO, but in any case, you should look to see if you can get your DAO upgraded to 3.6, it seems 3.6 fixes alot of problems with the older versions. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)