Object variable or With block variable not set (was "Frank")

When trying to upsize an access database to sql server using the upsize wizard, I get the following error:
"Object variable or With block variable not set."
Any assistance is greatly appreciated.sounds like an error in the vb code. try compiling in the vba window in access and see if it kicks out any errors. i have never used the upsizing wizard and I am not sure why sql server would care about the VBA|||Upsizing wizard creates an updateable recordset using DAO (!!!) and then attempts to insert rows using rs.AddNew...rs.Update sequence within a loop over the source. The error posted means that there was a failure to create a target recordset, most likely due to datatype incompatibility (this is all most likely unless some silly things are happaning like intermittent network connectivity failures and such).|||Thanks all for most helpful comments. Not too sure how to correct this in order to get a target recordset in that this is my first time doing this.

Any further comments welcomed.

Thanks once again for your time and effort in assistingme.