ODBC errors?

[Zoomiest]

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

 

[John Spencer]

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]

Thanks... where would I check for that? on the MySQL side?

 

[John Spencer]

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]

I got it now. Working 100% now.
THANK YOU!