Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 955
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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