Recent content by extrobe

In that example, the query is executing a stored procedure in SQLS, and returning the results to a recordset object. So unless I misunderstand, then I wouldn't be able to do that. Again, just confused as to what was going so badly wrong that it's killing access. Wondering if it's just a buggy...

Absolutely - I don't actually change it - I was setting it at 'run time' just so as to ensure it was correctly set - I can probably hard-set it in the properties and just leave it. (Edit: I've now made this change) But doesn't explain why it nukes access whenever I set it. And even if i don't...

Hello, I'm after a little bit of 'retrospective' help / advice on something. I have an Access application which has been developed through successive versions of access (from 95 onwards!), most recently in 2013 (and also tested in 2016). It's mainly lots of forms interacting with data in a...