Re: ODBC Connector in Access - All fields '#Deleted'

[Miguel Chenier]

I was having a similar problem this morning and have had other issues like it as I migrate to a MySQL and Access system. I highly recommend using 3.51.09 as .11 seems to cause many issues. And what solved my problem this morning was making my queries and the form that looked at the query use a snapshot rather than a dynaset query type. This only helps, of course, if you don't need to directly modify the data. The only difference between this data and the other that I have successfully integrated over the last two months is that it is contained in Memo type fields. The timestamp field seems to be a necessity also.