Hi,

I have to use Access and I am finding it extremely unstable when using FTP API calls.

Earlier today I had working code to connect and loop through files on an FTP server and return them to a listbox.

Now it kills access with the 'Do you want to recover..?' message on :

err.LastDllError


I thought this was a number? If so why is Access being so crap it cannot read it (sigh) ?


I doubt you guys will have any pointers for this as I am thinking VB6 was alittle more stable, but only a little However, if you have any pointers please do post.!

I have compiled it (compiles). Although I have now removed all but two references (and found that whilst it compiled before there was actually an error in the code) - VBA and Access Objects.

Any ideas apart from not using Access?