Greetings All,
I am trying to connect to a FileMaker Pro file via
ODBC, and I am getting the following error from the
ODBC manager...
[tt]Invalid field definition 'Adv UGD Call Back Date' in definition of index or relationship.[/tt]
I dont think this is a problem with Access or FileMaker
individually, but somewhere between the two (which
is why I am posting it here).
One thing I can tell that is different between this
field and most other ones is that this is a date field.
The ODBC driver for FileMaker allows for an option that
forces Dates & Numbers to be treated as text, and with
this checked, I still get the same error.
I checked, and there is no index on this field, but it
was checked to auto index as needed (which I disabled).
After trying this, and trying to enable the index for
this field it still wont work (same error message when
trying to connect).
I deleted the field, then I stopped getting the error
message (in a copy of the DB, so I still have the orig
Any ideas/suggestions?
Regards,
Tj
I am trying to connect to a FileMaker Pro file via
ODBC, and I am getting the following error from the
ODBC manager...
[tt]Invalid field definition 'Adv UGD Call Back Date' in definition of index or relationship.[/tt]
I dont think this is a problem with Access or FileMaker
individually, but somewhere between the two (which
is why I am posting it here).
One thing I can tell that is different between this
field and most other ones is that this is a date field.
The ODBC driver for FileMaker allows for an option that
forces Dates & Numbers to be treated as text, and with
this checked, I still get the same error.
I checked, and there is no index on this field, but it
was checked to auto index as needed (which I disabled).
After trying this, and trying to enable the index for
this field it still wont work (same error message when
trying to connect).
I deleted the field, then I stopped getting the error
message (in a copy of the DB, so I still have the orig
Any ideas/suggestions?
Regards,
Tj