ACC97: Importing/Linking Certain Files Via FTP Generates Error

• Microsoft Access 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you import or link certain types of files from an FTP site in Microsoft Access 97, you may receive an error message.

If you try to import or link a table from a Microsoft Access database, you receive the following error message:

    Not a valid file name.

    You cannot use an Internet address here. Enter a path that points to a
    location on your computer or on the network.

   Bad file name or number

CAUSE

For text files, Microsoft Access uses an Open File command to populate the wizard with data; the Open File command does not support FTP.

For Microsoft Access databases, this behavior is by design. Microsoft Access does not support importing or linking a Microsoft Access database on an FTP server.

RESOLUTION

You can copy or move the file to a local hard drive, floppy disk, or network drive, and then import or link the file.

You can import a text file from an FTP site if you use the TransferText action or method and import the file through a macro or Visual Basic for Applications code.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

The following example demonstrates the error by trying to import a text file.

1. Create a text file on an FTP share.

2. Start Microsoft Access and open the sample database Northwind.mdb.

3. On the File menu, point to Get External Data, and then click Import.

4. Type the path to your FTP server in the File Name box, for example, FTP://MyFTPServer.

5. Select Text Files in the Files Of Type box.

6. Select your text file, and click the Import button. Note that your receive the following error message:

          Bad file name or number
   

REFERENCES

For more information about importing or linking data from FTP sites, search the Help Index for "FTP sites, importing and linking files."

For more information about importing or linking data in Microsoft Access, search the Help Index for "importing data, importing data" or ask the Microsoft Access 97 Office Assistant.