Annoying problem here - am trying to use TransferText method (have tried both via Macro and VBA) but continue to get the message 'The Microsoft Jet Database Engine cannot open the object '[Name of My text File]. It is already opened exclusively by another user, or you need permission to view its data'
Have looked at everything, have tried to rename files with .txt extension, have made sure permissions are set correctly etc. - the only remote possibility of a 'reason' is what I found under http://www.mvps.org/access/bugs/bugs0046.htm which talks about adding registry keys etc. As I am not the administrator of this machine I'm trying all other possibilities first - anyone out there who might be able to help?