[RESOLVED] MS Access VBA - FTP APIs

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) ?
:eek2:

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?

Access is one of the wrong ways to use FTP. C is probably better, but if you know VB6 better than you know C, it's pretty stable for FTP (I use a VB6 FTP client all the time).

I have an Access module of code that FTP's bar code packing slip electronic data to Boeing. So it is possible and I did it with a template of the allapi ftp apis. Search the forums for my code. :)

Thanks for the assist.


Seems Access wasn't stable, patched with latest updates and still the same error occurs (converting err.lastdll to a number for comparison).

Had to re-write looking at the filename instead to get it not to crash.

:thumb: