darragh murray

This is a quick little tip.
I came across a minor annoyance the other day when I was importing Access saved queries from another database and using link tables. If you import your queries before you link your tables, then try run the queries with no tables link - Access will complain that it can’t find [...]

Read the rest of this entry »

I recently encountered a problem that I’ve actually encountered millions of times before - trying to run an SQL string from VBA code which makes use of double apostrophe’s (””). Naturally, VBA uses these to break from a string literal, but pure Jet-SQL uses them for functions like Format() and Nz().
So if you do [...]

Read the rest of this entry »