In your Open statement you need to replace adOpenStatic with adOpenKeyset or adOpenDynamic