[AccessD] Export to dBase

Iirc the limit's 10 but it may vary by version. But I agree that's the
problem. The export simply truncates your field names and if you have two
which are not unique within the first 10 characters then you get this. As
Erwin suggests, create a query where you can dictate the output names, and
export that.

Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Erwin Craps - IT Helps
> Sent: 16 December 2003 07:26
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Export to dBase
> 
> 
> DBF is limited to 8 character fields names (can be different 
> depending on DBF version).
> 
> I don't remember exacly what happends in access if you have 
> for example txo field named:
> 
> CustAddressLine1
> CustAddressLine2
> Both could be truncated to CustAddr.
> 
> Create a query putting your own fieldnames at 8 chars like 
> this. CustAdd1 :[CustAddressLine1] CustAdd2 :[CustAddressLine2]
> 
> Erwin Craps
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Lonnie Johnson
> Sent: Tuesday, December 16, 2003 2:39 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Export to dBase
> 
> When I get this message it's when I have taken a field from 
> the table and moved it on the grid more than once.
>  
> 
> 
> Reuben Cummings <reuben at gfconsultants.com> wrote:
> I am trying to export some queries to dBase files.
> 
> However, on some of the queries I get Error 3191, "Cannot 
> define field more than once"
> 
> Anyone care to explain what's wrong?
> 
> Thanks.
> 
> Reuben Cummings
> GFC, LLC
> phone: 812.523.1017
> email: reuben at gfconsultants.com
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
> Lonnie 
> Johnson
> ProDev, Professional Development of MS Access Databases Visit 
> me at ==> http://www.prodev.us
> 
> 
> 
> 
>  
> 
> 
> 
> 
> ---------------------------------
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>