Hi all,
I have a SQL server 2000 table attached to my Access 97 database. I am attempting to update a table, however, when I run the code below, I get "MSACESS has caused an invalid page fault in module Kernel32.dll"
CurrentDb.Execute "UPDATE tblActiveChase SET AddressID = " & lAddresseeID & ", AddressTo = '" & sAddressTo & "', Addressdear = '" & sAddressDear & "', Address1 = '" & sAddress1 & "', Address2 = '" & sAddress2 & "', Address3 = '" & sAddress3 & "', Address4 = '" & sAddress4 & "', Address5 = '" & sAddress5 & "', AddressPC = '" & sAddressPostCode & "', AddressDX = '" & sAddressDX & "', Tel1 = '" & sTel1 & "', Tel2 = '" & sTel2 & "', Tel3 = '" & sTel3 & "' Where fileid = " & lExpediaNo & " AND ChasetypeID = " & lChaseTypeID & ";", dbSeeChanges + dbFailOnError
This is very odd as it runs OK when I run a very similar line of code:
CurrentDb.Execute "UPDATE tblActiveChase SET AddressID = " & lAddresseeID & ", AddressTo = '" & sAddressTo & "', Addressdear = '" & sAddressDear & "', Address1 = '" & sAddress1 & "', Address2 = '" & sAddress2 & "', Address3 = '" & sAddress3 & "', Address4 = '" & sAddress4 & "', Address5 = '" & sAddress5 & "', AddressPC = '" & sAddressPostCode & "', AddressDX = '" & sAddressDX & "', Tel1 = '" & sTel1 & "', Tel2 = '" & sTel2 & "', Tel3 = '" & sTel3 & "' Where FileID = " & lExpediaNo & " AND ChaseTypeID IN (SELECT ChaseTypeID FROM tblChaseType WHERE ChaseAddress ='" & sChasee & "');", dbSeeChanges + dbFailOnError
Any ideas ? Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com
I have a SQL server 2000 table attached to my Access 97 database. I am attempting to update a table, however, when I run the code below, I get "MSACESS has caused an invalid page fault in module Kernel32.dll"
CurrentDb.Execute "UPDATE tblActiveChase SET AddressID = " & lAddresseeID & ", AddressTo = '" & sAddressTo & "', Addressdear = '" & sAddressDear & "', Address1 = '" & sAddress1 & "', Address2 = '" & sAddress2 & "', Address3 = '" & sAddress3 & "', Address4 = '" & sAddress4 & "', Address5 = '" & sAddress5 & "', AddressPC = '" & sAddressPostCode & "', AddressDX = '" & sAddressDX & "', Tel1 = '" & sTel1 & "', Tel2 = '" & sTel2 & "', Tel3 = '" & sTel3 & "' Where fileid = " & lExpediaNo & " AND ChasetypeID = " & lChaseTypeID & ";", dbSeeChanges + dbFailOnError
This is very odd as it runs OK when I run a very similar line of code:
CurrentDb.Execute "UPDATE tblActiveChase SET AddressID = " & lAddresseeID & ", AddressTo = '" & sAddressTo & "', Addressdear = '" & sAddressDear & "', Address1 = '" & sAddress1 & "', Address2 = '" & sAddress2 & "', Address3 = '" & sAddress3 & "', Address4 = '" & sAddress4 & "', Address5 = '" & sAddress5 & "', AddressPC = '" & sAddressPostCode & "', AddressDX = '" & sAddressDX & "', Tel1 = '" & sTel1 & "', Tel2 = '" & sTel2 & "', Tel3 = '" & sTel3 & "' Where FileID = " & lExpediaNo & " AND ChaseTypeID IN (SELECT ChaseTypeID FROM tblChaseType WHERE ChaseAddress ='" & sChasee & "');", dbSeeChanges + dbFailOnError
Any ideas ? Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com
