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

VBA FTP Upload from Access 2010 64-BIT

I have been looking for a way to upload/download files from an FTP site.  I found some that work with 32-bit Access, but fail with 64-bit.

Any ideas on how to do this?

Thank you in advance.
0
Scamquist
Asked:
Scamquist
  • 5
  • 3
1 Solution
 
MacroShadowCommented:
Haven't tested this but give it a try.
FTP-Demo.mdb
0
 
AlexPaceCommented:
What problem were you having?  Was it a file permissions issue?  Was the DOS command line FTP client not installed?
0
 
ScamquistAuthor Commented:
AlexPace
I have had a problem getting started.  I searched and tried to cobble some code together and usually had errors that the code would not work with 64 bit software.  Also, I didn't see anything about dos FTP commands
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
MacroShadowCommented:
Did you check my attachment?
0
 
ScamquistAuthor Commented:
MacroShadow.  I downloaded but there isn't a table named tblFTPFileList.  Also, the one of the modules will not compile.  I will try to determine the fields for the table and debug the code.
0
 
ScamquistAuthor Commented:
Long delay.  I'm sorry.  Just settling in to a new position.



I created the table tblFTPFileList, but the complie fails at:

    ret& = CreateProcessA(0&, Pathname, 0&, 0&, 1&, NORMAL_PRIORITY_CLASS, 0&, 0&, start, proc)

in the Public Sub ShellWait(Pathname As String, Optional WindowStyle As Long)

Will this work with Access 2010 64-bit.  I though the API functions were different in 64-bit.
0
 
MacroShadowCommented:
Will this work with Access 2010 64-bit.
I thought it would.

I though the API functions were different in 64-bit.
They are. I updated the code to accommodate a 64-bit system.

I'm afraid I can't help you any more, I don't have a 64-bit machine.
0
 
ScamquistAuthor Commented:
The sample database does not work with 64-bit access.  I found a way around by using NetDrive, assigning a drive letter and using TransferSpreadsheet.
0
 
ScamquistAuthor Commented:
I abandoned trying to use VB to solve the problem.  NetDrive assigns the FTP site with a drive letter and TransferSpreadsheet moves the file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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