Problem: Do you have to specify the drive letter when you create an table that references external file? I worked through the example on p. 82 of the Data Definition Guide for Create Table. Then I did a Show Metadata. The metadata definition shows drive that the file is always located on drive c: -- regardless of the drive letter it really resides on. Solution: Yes, you do need to specify the full path of the file. Otherwise, InterBase will attempt to reference the file in a path on drive "c". It does not check to see that the file is there. It will not default to the directory name where the database is located. You have to specify the full path and file name correctly for your external table definition to work correctly.
Last Modified: 26-OCT-00