ACC2000: "Couldn't Find Object" Error Exporting Query to dBASE

• Microsoft Access 2000

SYMPTOMS

When you try to export a query in dBASE (any version) file format, you may receive the error message, "Couldn't find object queryname.dbf." If you try to save the underlying table to dBASE format, you receive the following error message:

Cannot define field more than once.

CAUSE

dBASE has a 10-character limit for the size of field names. When the first 10 characters of two (or more) fields in a Access table are identical, if you try to export the table or query in dBASE file format, there will be duplicate field names.

RESOLUTION

To work around this behavior, use one of the following approaches:

1. Rename the table fields so that the first 10 characters are unique for each field.



2. Alias the field names in a query. For example, in the query Field row type: [NewField]:[OldDuplicateField]

MORE INFORMATION

Steps to Reproduce Behavior

1. Create the following table:




   Table: Table1
   ------------------------
   Field Name: abcdefghijk
   Data Type : Text

   Field Name: abcdefghijkl
   Data Type : Text 

2. Create a query based on Table1 that includes both fields.



3. On the File menu, click Export.



4. In the Export Table dialog box, under Save As Type, select dBASE III (*.dbf), and then click Save.
   
   Note that you receive the following error message:




Couldn't find object Table1.dbf

REFERENCES

For more information about exporting to an Xbase file, click Microsoft Access Help on the Help menu, type "dbase" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words: dBASE duplicate names pra

Keywords : kb3rdparty kbdta IsmXbase
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug