• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3221
  • Last Modified:

MS Access 2010 VBA FTP

I am trying to upload a file via FTP in a procedure. I have researched various links on how to do this, but they seem to refer to older Access Versions, and I receive error messages when trying to use in Access 2010, stating that the code was written for older versions. Can someone point me in the correct direction for this. The information I tried to use was:

 Internet Data Transfer Library - http://access.mvps.org/access/modules/mdl0037.htm

Thank you
0
Rick Rudolph
Asked:
Rick Rudolph
  • 3
  • 2
1 Solution
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Here is the code is use with Access 2010 32-bit.

See:  FTP Client functions

** Note:  It has not been converted to work with Access 2010 64-bit
0
 
Rick RudolphAuthor Commented:
Thank you, I am in a 64 bit environment, and did not realize I should mention that.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
If you are running Access 2010 64-bit, you will have to modify same VBA code to get it to work. . Especially any Windows API calls.

Most VBA code examples will work in new versions excepy when switching to Access 2010 64-bit.   Because of all the issues with Access 2010 64-bit, most people avoid it. That is why you are not finding many example for Aces 2010 64-bit.

See:

 Compatibility Between the 32-bit and 64-bit Versions of Office 2010


Declare Statment And Ptrsafe Attribues, Office 2010

FWIW:
"Office 2010 (64 bit versions) "
Well ... at the 2010 mvp summit (2011 in 2 weeks) ... the Access product peeps specifically told us ... "avoid O2010x64 unless you really need super giant large Excel spreadsheets"
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Here is a previous question related to the same issue that I answered:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28153370.html#a39236338
0
 
Rick RudolphAuthor Commented:
Well I was wrong....I'm on a 64 bit server, but the Office is 32 bit. I will go back and review all of the suggestions to date and then update the question as to what seems to work. Thank you.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now