Have you tried help? I just opened Access 2003 and looked for FTP. The answer seems to be there. I'll post it just in case it isn't in other versions:
Work with FTP
You can save data access pages to an FTP (FTP: A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands, such as listing files and folders, to work with files on a remote location.) file server. You can also customize the way you work with FTP sites.
Save a data access page to an FTP site
To do this procedure, your company must have an intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.), or you must have access to an Internet (Internet: A worldwide network of thousands of smaller computer networks and millions of commercial, educational, government, and personal computers. The Internet is like an electronic city with virtual libraries, stores, art galleries, and so on.) site that supports saving files. In addition, you must have access rights to save, and you must add the FTP site to your list of FTP locations.
If the data access page you want to save to an FTP site isn't already open, open it in Page view (Page view: An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Internet Explorer 5.0 or later.) or Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.). The page you want to save can be a new data access page that has never been saved or an existing data access page.
On the File menu, click Save As.
In the Save As dialog box, type a name for the link to the data access page and click OK.
In the Save As Data Access Page dialog box, click FTP Locations in the Save In box.
In the list of FTP sites, double-click the site you want, and then double-click the location you want to save the data access page to.
Note You must have write permissions for the FTP location to save the data access page there.
In the File name box, type a name for the .htm file.
Click Save.
Add an FTP site to the list of FTP locations
You can add an FTP site to the FTP Locations list in the Open and Save As dialog boxes. To do this, your company must have an intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.) or you must have access to the Internet (Internet: A worldwide network of thousands of smaller computer networks and millions of commercial, educational, government, and personal computers. The Internet is like an electronic city with virtual libraries, stores, art galleries, and so on.)— for example, you could have a modem and an Internet account through a service provider (ISP: A business that provides access to the Internet for such things as electronic mail, chat rooms, or use of the World Wide Web. Some ISPs are multinational, offering access in many locations, while others are limited to a specific region.), or you could have access through your corporation's network.
On the File menu, click Open.
In the Look In box, click Add/Modify FTP Locations.
In the Name of FTP site box, type the FTP site name; for example, type ftp.microsoft.com.
To log on to a site anonymously, click Anonymous (some sites don't allow this).
To log on to a site you have user privileges for, click User, type your logon name, and then type your password if prompted.
Click Add.
Remove an FTP site from the list of Internet sites
On the File menu, click Open.
In the Look In box, click FTP Locations.
Right-click the FTP site you want to remove, and then click Remove on the shortcut menu.
Change the logon name or password for an FTP site
You can change the way you log on to an FTP site. To do this procedure, your company must have an intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.) or you must have access to the Internet (Internet: A worldwide network of thousands of smaller computer networks and millions of commercial, educational, government, and personal computers. The Internet is like an electronic city with virtual libraries, stores, art galleries, and so on.)— for example, you could have a modem and an Internet account through a service provider (ISP: A business that provides access to the Internet for such things as electronic mail, chat rooms, or use of the World Wide Web. Some ISPs are multinational, offering access in many locations, while others are limited to a specific region.), or you could have access through your corporation's network.
On the File menu, click Open.
In the Look In box, click FTP Locations.
Right-click the FTP site you want to change, and then click Modify on the shortcut menu.
Change the options you want.