[RESOLVED] Transfer Text Error

Hi guys,

I've run into an error regarding the Transfer Text component of an Access Macro. The command is trying to import the contents of a .txt file (based on a spec) into a table. Previously this macro has run smoothly, however today the database is crashing upon trying to execute this command. The Exception information associated with the Error Report indicates this -

Code: 0xc0000005

I've googled that code and it appears to be an access violation? I'd greatly appreciate any help as I'm stuck on this one.

Thanks

check to make sure the table is not in use
the file is not in use...etc..

try importing to a new table..

It definitely wasn't in use. I deleted a bunch of Import Error tables that had been created by previous executions of the macro and now it seems to be working, although I'm none the wiser for it. :ehh:

If anyone can think of why that worked, feel free to post. Thanks for you help again, Static - much appreciated.