Hi
I have to make export of SQL Server Database to MS Access and I have
done it with the tables but now I need to transfer(export) the
relations, keys and indexes. Can any1 tell me how to read relations,keys
and indexes from SQL Server and convert them to MS Access.(it seams that
for creation of indexes in MS Access ADOX is the only way but ADOX
cannot read all information about keys,indexes from SQL Server.)
All I can see is that I have to use SQLDMO to enumarate all
realtion/keys/indexes from SQL Server database and use ADOX to create
this relations/keys/indexes in MS Access database, but I don't know
exact matching attributs of relations/keys/indexes from SQL to Access.

Thanks

Hi

You posted the same question in microsoft.public.sqlserver.programming. If
you are not sure about the answers you were given then please do not cross
post.

John
"Bose" <bosejob (AT) sympatico (DOT) ca> wrote

I do that becouse I didn't get the answer. I need some page where I can
see Access contraparts of SQL Server keys/indexes.

John Bell wrote:

Hi

I don't think you will get a more authorative answer than from Mary.

Have you considered MSDE?

John

"Bose" <bosejob (AT) sympatico (DOT) ca> wrote