Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 208446 - Last Review: June 24, 2004 - Revision: 2.0
ACC2000: Errors Messages When You Export Query to dBASE
This article was previously published under Q208446
Novice: Requires knowledge of the user interface on single-user computers.
When you try to export a query in dBASE (any version) file format,
you receive the following error message:
Couldn't find object queryname.dbf.
When you try to save the underlying table to dBASE format, you receive the following error message:
Cannot define field more than once.
When you try to export the query using the
TransferDatabase method, you receive the following error message:
Run-time error '3191':
Can't define field more than once.
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.
To work around this behavior, use one of the following approaches:
- Rename the table fields so that the first 10 characters are unique for each field.
- Alias the field names in a query. For example, in the query Field row type: [NewField]:[OldDuplicateField]
Steps to Reproduce Behavior
- Create the following table:
Table: Table1
------------------------
Field Name: abcdefghijk
Data Type : Text
Field Name: abcdefghijkl
Data Type : Text
-
Create a query based on Table1 that includes both fields.
-
On the File menu, click Export.
-
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
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.
APPLIES TO
- Microsoft Access 2000 Standard Edition
| kbbug kbnofix kb3rdparty KB208446 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate