Thread: Updating Data to Access Error
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
cmart02[_2_] cmart02[_2_] is offline
external usenet poster
  
Posts: 18
Default Updating Data to Access Error
Pete,

Try changing as follows:

Set rs = dbs.OpenRecordset("Select * From WS Where SSN =" & FSSN & ";",
dbOpenDynaset)

This should do the trick.

Regards
Robert
Reply With QuoteReply With Quote