Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Tue Dec 16 01:25:55 CST 2003
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/accessd 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/accessd Website: http://www.databaseadvisors.com