|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 17th, 2010, 01:51 PM
posted to microsoft.public.access.queries
|
|||
|
|||
ODBC errors?
I have a webserver hosted in my basement running a MySQL database. I
am using ODBC to connect to it, and run queries with MS Access. I have done this for years, and am setting up this environment again. When I try to link to the remote tables (Access 2007) I can link to all the tables but one (an important one), containing contact information. It has a 'title' field. The error I get back is " 'IDX_title' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not tool long." But when I go look at the db, through myPHPAdmin, the title field does not have the extra "IDX_" part. Any thoughts? Zoomiest Calgary, Alberta 
|
|
#2
March 17th, 2010, 04:25 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
ODBC errors?
Sounds as if there is an index being created on the field named IDX_Title.
And that is causing the error. See if there is such an index and if so see if you can delete it or rename it. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Zoomiest wrote: I have a webserver hosted in my basement running a MySQL database. I am using ODBC to connect to it, and run queries with MS Access. I have done this for years, and am setting up this environment again. When I try to link to the remote tables (Access 2007) I can link to all the tables but one (an important one), containing contact information. It has a 'title' field. The error I get back is " 'IDX_title' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not tool long." But when I go look at the db, through myPHPAdmin, the title field does not have the extra "IDX_" part. Any thoughts? Zoomiest Calgary, Alberta
|
|
#3
March 18th, 2010, 04:42 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
ODBC errors?
Thanks... where would I check for that? on the MySQL side?
On Mar 17, 10:25*am, John Spencer wrote: Sounds as if there is an index being created on the field named IDX_Title.. And that is causing the error. *See if there is such an index and if so see if you can delete it or rename it. John Spencer
|
|
#4
March 18th, 2010, 07:08 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
ODBC errors?
I would check there as that is where I would expect to see such an index.
John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Zoomiest wrote: Thanks... where would I check for that? on the MySQL side? On Mar 17, 10:25 am, John Spencer wrote: Sounds as if there is an index being created on the field named IDX_Title. And that is causing the error. See if there is such an index and if so see if you can delete it or rename it. John Spencer
|
|
#5
March 20th, 2010, 02:09 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
ODBC errors?
I got it now. Working 100% now.
THANK YOU! On Mar 18, 1:08*pm, John Spencer wrote: I would check there as that is where I would expect to see such an index. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
