PDA

View Full Version : ODBC link with Access


nickholmes
04-09-03, 20:46
I am trying to get Access to read some data from a Filemaker 5 database using ODBC.

I have finally got a link, but Access gives me an error stating that there are too many indexes.......

As far as Filemaker is concerned, there are only 3 indexes (found using File > Define Fields). Access can handle up to 32 indexes per table.

Does anyone know what Access is picking up as indexes?

I know very little about Filemaker, so any help will be greatly appreciated.

Thank you

Nick

omiossec
04-12-03, 05:10
Originally posted by nickholmes
I am trying to get Access to read some data from a Filemaker 5 database using ODBC.

I have finally got a link, but Access gives me an error stating that there are too many indexes.......

As far as Filemaker is concerned, there are only 3 indexes (found using File > Define Fields). Access can handle up to 32 indexes per table.

Does anyone know what Access is picking up as indexes?

I know very little about Filemaker, so any help will be greatly appreciated.

Thank you

Nick

Filemaker can create dynamicly index see file > define field > field options