Welcome, Guest. Please Login.
05/03/24 at 01:49:56
News:
Home Help Search Login


ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
invalid field name (Read 1859 times)
fdiala
Full Member
***




Posts: 102
Gender: female
invalid field name
09/25/06 at 11:21:46  
Hello All,
 
I am linking the tables to MSAccess. The ODBC works fine except in some tables where the field name contains spaces, it not importing/linking.  
 
Any suggestions.
 
Thanks,
 
Diala
Back to top
 
 
Diala Farroukh
Raytron Ltd
3870 Griffith, VSL, QC
Canada H4T 1A7
dfarroukh@raytron.ca
DBA Classsic 2004.1 IsTechUpdate 04-04-13 SP2
fdidi_2   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: invalid field name
Reply #1 - 09/25/06 at 13:01:41  
I dont know of any table that has fields with spaces on it.
 
Try to recreate you ODBC DSN connections.
 
Regards,
 
Kelloggs
Back to top
 
 
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
fdiala
Full Member
***




Posts: 102
Gender: female
Re: invalid field name
Reply #2 - 09/26/06 at 04:17:01  
I tried several times, still not working, look at table MTICMSTR & WORKORD. They have column names like "MTIC_PROD_SPECS[  1]" and "MTWO_WIP_INSTR[  1]" between the brackets and the number there is a space which is causing a problem in importing or linking. Any ideas?
 
Thanks,
 
Diala
Back to top
 
 
Diala Farroukh
Raytron Ltd
3870 Griffith, VSL, QC
Canada H4T 1A7
dfarroukh@raytron.ca
DBA Classsic 2004.1 IsTechUpdate 04-04-13 SP2
fdidi_2   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: invalid field name
Reply #3 - 09/26/06 at 06:37:59  
I just looked at my WORKORD table in Access and the field you mentioned is showing up as MTWO_WIP_INSTR_1 with no brackets and no space.  I don't know why it is different from what you are looking at.
Back to top
 
 
Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
HB
Full Member
***


I love DBA

Posts: 216
Gender: male
Re: invalid field name
Reply #4 - 09/26/06 at 08:02:37  
that is the way they show up in "Maintain Databse"  
In the linked table it shows as xx _1
Back to top
 
 
Helmut Bode
General Pencil Co.
DBA Classic 2004.1 w/IS Tech update 7/25/13
EVO-ERP
Pervasive 11
Win2008 Server
Terminal Server
12 Users
Email   IP Logged
fdiala
Full Member
***




Posts: 102
Gender: female
Re: invalid field name
Reply #5 - 09/27/06 at 05:01:19  
I fixed it, I had to delete the DSN from the server and re-create it with checking the ome/ansi option. It does not work if you click the option after you creat the DSN.
 
Thanks for all,
 
Diala
Back to top
 
 
Diala Farroukh
Raytron Ltd
3870 Griffith, VSL, QC
Canada H4T 1A7
dfarroukh@raytron.ca
DBA Classsic 2004.1 IsTechUpdate 04-04-13 SP2
fdidi_2   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge