CREATE INDEX ddl for ODBC tables

[jkirkland]

I am trying to create a non-unique index on a linked ODBC table but when I use the following code I get a unique index and the field is set as the primary key.

currentDB.execute "CREATE INDEX idx1 ON tbl210AP(Fund);"

Does access only allow unique indexes on linked ODBC tables or is there a way to make this field a non-unique index?

Thanks!

 

[ZmrAbdulla]

This (

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp)

must be a useful page for you.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.

 

[jkirkland]

Thanks! I've actually read it recently though trying to find out more about the so called "pseudo indexes" tht can be made on linked ODBC tables but it doesn't appear to reference multiple, non-unique indexes. There's an additional reference to this pseudo indexes at:

http://msdn.microsoft.com/archive/d...e/en-us/office97/html/output/F1/D2/S5A31F.asp

Has anyone been able to find a work around to either create a non-unique index on an linked ODBC table and/or multiple, non-unique indexes on a linked ODBC table?

Thanks

 

[HeathRamos]

I can't figure this out either.

 

[jkirkland]

I don't suppose anyone out there has any more info on this topic?