access 2003: ftp question - Microsoft Access / VBA

How can I use FTP from Access 2003 with Windows 2003.
Any suggestions?
Thanks - jung

Nov 13 '05 #1

3619

you can use the runapp command in a macro to try running the
c:\windows\syst em32\ftp.exe program

this is the ftp program that is run from the command prompt when you type in
something like "ftp 123.123.123.123 "

you would have to figure out a way to make it interact for opening the
connection and logging in and such--this is most easily accomplished with a
file containg ftp commands (see the help for ftp by typing ftp /? at the
command prompt or by doing a search in windows help)

you can also run this by using the Visual Basic SHELL object if you are
looking to do it using VB code--this is more flexible ( i think) but more is
involved.

Are you looking to ftp something that is coming from access itself (a table,
report, etc)?

"JMCN" <pi******@yahoo .fr> wrote in message
news:27******** *************** ***@posting.goo gle.com...

How can I use FTP from Access 2003 with Windows 2003.
Any suggestions?
Thanks - jung

Nov 13 '05 #2

Pieter Linden

pi******@yahoo. fr (JMCN) wrote in message news:<27******* *************** ****@posting.go ogle.com>...

How can I use FTP from Access 2003 with Windows 2003.
Any suggestions?
Thanks - jung

There's code here...
http://vbnet.mvps.org/

FTP: Downloading Files via FTP
and here...
http://www.mvps.org/access/modules/mdl0015.htm

Nov 13 '05 #3

JMCN

pi********@hotm ail.com (Pieter Linden) wrote in message news:<bf******* *************** ****@posting.go ogle.com>...

pi******@yahoo. fr (JMCN) wrote in message news:<27******* *************** ****@posting.go ogle.com>...
How can I use FTP from Access 2003 with Windows 2003.
Any suggestions?
Thanks - jung

There's code here...
http://vbnet.mvps.org/

FTP: Downloading Files via FTP
and here...
http://www.mvps.org/access/modules/mdl0015.htm

thank you all for your advise and resources!!
cheers - jung

Nov 13 '05 #4

Similar topics

4188

Versions of Access needed A2K MDE? Runtime?

by: wolftor | last post by:

1) Is there a free runtime version of Access available that is more recent than the one for Access 2000? 2) If I create an application (MDE) in A2K, will it run on all later versions of Access? 3) If I create a CD using A2K Developer that includes the runtime version of Access 2K and an installation package, and if someone tries to install the application from the CD, what happens if someone already has Access 2000 or a later version...

Microsoft Access / VBA

2811

Different version of Access for frontend and backend.

by: Squirrel | last post by:

I've developed an Access 2002 database which will be deployed with the backend on a server and frontend on the users' PCs. I've now been advised that new employees will be given laptops with Access 2003 installed and that the server software will not be updated. Also some of the users are using Access 2000 and some Access 2002. My question is - will this work? There is a lack of IT support in this department - they've contracted with...

Microsoft Access / VBA

1724

Access 97 upgrade question

by: DonLi | last post by:

Hi, I have a copy of Access 97 while my client uses Access 2000 which supports Unicode. My client has ordered a copy of Access 2000 upgrade for me, but the middleman, atomicpark.com is totally ABSURD, first they delayed delivery and secondly when they sent the ordered product they sent me a badly damaged CD, when I asked for replacement they did not even bother to apologize instead telling me to contact them. I don't ever ever want to...

Microsoft Access / VBA

4449

Access Developer's Edition

by: Johnny Meredith | last post by:

Hi all, I'm interested in getting the Access Developer's edition. Here's my question: where do I go to get it? At Microsoft, there's a Access 2003 Developer's Extensions package, as well as some other packages with mention the .Net framework. ($499 was the price tag on that, which was what I was expecting for the Developer's edition of Access.) Also, I have purchased a copy of Visual C# .Net Standard edition and I hope to

Microsoft Access / VBA

3052

Totally confused about Access 2003 Runtime availability!

by: Lauren Wilson | last post by:

Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the Runtime? I just purchased Office 2003 Professional. Is Access 2003 Runtime included with that or not? It APPEARS that the only way I can get Access 2003 Runtime is to

Microsoft Access / VBA

5260

Future of access?

by: John | last post by:

Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping that everyone migrates to vs/sql. Any comments? Thanks

Microsoft Access / VBA

9981

Access 2002 vs. 2003

by: Neil | last post by:

We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server 2005, and, since he already has licenses for Office Pro 2002, he wants to upgrade to that. I've been saying that we need to upgrade to Access 2003, not 2002, even if Office is kept at 2002. We are also looking to do a fair amount of...

Microsoft Access / VBA

2400

Access 2K3: Globally disable control tips?

by: Cheryl Langdon | last post by:

Does anyone know if there is a way to globally turn off ALL control tips in Access 2003 using VBA code? Thanks. --- CL

Microsoft Access / VBA

2699

ms-access 2007 online? How can users log on to access 2007 from theinternet?

by: raylopez99 | last post by:

10 years ago, the below was written (see very end, after my signature RL). What, if anything, has changed? I have Access 2003 and soon Access 2007 on a Windows XP Professional or Windows Vista Ultimate machine, with SQL Server Express running on it, and I want somebody, with a password (which I will provide) to be able to log onto a A03 or A07 dB from the internet. Now that I type this I realize that unless I put the database onto a...

Microsoft Access / VBA

2416

Sharing .MDB between Access 2.0 and Access 2003

by: Moor | last post by:

I have a .MDB back-end database that is created with Access 2.0. And multiple front-end mdb's, some are created by Access 2.0, and the rest are created by Access 2003. The fron-ends had table attachments to the back-end database. The problem is I'm unable to access any table by both versions of Access in the same time! Here are the steps to replicate the problem 1- Open one Access 2.0 front-end mdb, then open the attached table T1

Microsoft Access / VBA

9398

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10156

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10007

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9832

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8831

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5419

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3924

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3531

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2805

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General