Thanks to the contributors in this thread - it helped a bunch! Just three things to add:

1. My Jet registry key was under HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/Microsoft/Jet...

2. Setting TypeGuessRows to 0...