[RESOLVED] MS Access VBA - FTP APIs

Ecniv · Mar 19th, 2007, 11:00 AM

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?

Al42 · Mar 19th, 2007, 01:07 PM

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).

RobDog888 · Mar 19th, 2007, 06:52 PM

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.

Ecniv · Mar 21st, 2007, 04:37 AM

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.

Mar 19th, 2007, 01:07 PM	#2
Al42 PowerPoster Join Date: Feb 06 Location: East of NYC, USA Posts: 5,692	Re: MS Access VBA - FTP APIs 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). __________________ The most difficult part of developing a program is understanding the problem. The second most difficult part is deciding how you're going to solve the problem. Actually writing the program (translating your solution into some computer language) is the easiest part. Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read. Please Help Us To Save Ana

Mar 19th, 2007, 06:52 PM	#3
RobDog888 Super Moderator Join Date: Apr 01 Location: LA, Calif. Raiders #1 AKA:Gangsta Yoda™ Posts: 58,875	Re: MS Access VBA - FTP APIs 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. __________________ VB/Office Guru™ (AKA: Gangsta Yoda™ ®) I dont answer coding questions via PM. Please post a thread in the appropriate forum. Microsoft MVP 2006, 2007, 2008, 2009, 2010 Office Development FAQ (VBA, VB 6, VB.NET, C#) Software Engineer MCP (VB 6 & .NET), BSEE, CET If a post has helped you then Please Rate it! • Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility • System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)