I have a form and i display data from sql server on this form



sSQL = "SELECT * from View_Detail"
conMyConnection.ConnectionString = MyConnectionString
conMyConnection.Open
rsOutputList.Open sSQL, conMyConnection, adOpenStatic, adLockPessimistic
Set Me.Recordset = rsOutputList



this works fine but after 4-5 times if i open this then i don't see anything, if i go to design view then i see that RecordSource property of form has saved this string "SELECT * from View_Detail" and this table is not in access and it searches for it and don't open form.


if i delete this line from record source property then form works well again.
and help please.