I am using MSDAORA and if i use adocon.begintrans and then do an insert and then crash the app i.e. close the db connection before i do a commit or rollback the insert is committed. Why is this and is there any way to make a rollback occur if the connection to the db is lost?
Can someone point out what is wrong with this query? It works when I remove the RaisedDate criteria. RaisedDate is defined as DateTime. This is running in VB.Net against an Access XP database.