ODBC connection

[Guest]

I have code the refreshes my ODBC link to some Oracle tables. The only
problem that I having is that I need to be able to set up a unique record
identifier when the table is refreshed. Any help would be great!

TIA,
K

 

[Alex Dybenko]

Hi,
AFAIR - you can do this running DDL query on attached table, like:

Alter Table MyTable Create Index ...

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Douglas J. Steele]

If I'm understanding your question correctly, see the GenerateIndexSQL code
in http://www.accessmvp.com/DJSteele/DSNLessLinks.html