metadata access

[Paul-Adrien]

Hello,

How can I find the metadas of my access database considering that the method
;OleDbDataReader.GetSchemaTable() doesn't work.

It can't find The "AllowDBNull" property if the column is not a primary key.

Thanks,

Paul-Adrien

Ps: Sorry for basics mistakes my English level isn't very good.

 

[John W. Vinson]

Hello,

How can I find the metadas of my access database considering that the method
;OleDbDataReader.GetSchemaTable() doesn't work.

It can't find The "AllowDBNull" property if the column is not a primary key.

Thanks,

Paul-Adrien

Ps: Sorry for basics mistakes my English level isn't very good.

Access is not SQL/Server. It doesn't have a "metadata" table in the same way
(well, there is a table MSysObjects but it's altogether different in structure
and usage).

To view properties of Tables you can use VBA code to examine the Tabledef
object. See the online help for Tabledef.

Perhaps you could post what you're trying to accomplish, rather than how
you're trying to accomplish it.

 

[Paul-Adrien]

You are right my question wasn't very clear but thank you for your answer.

I'm working for the holidays on a project which could permit to create a
script permitting to copy different data sources (access, excel, mysql, xml,
etc.) on a sql server data base.

I need a script in order to integrate it in a setup.

As the data sources i have to copy change very often this project could be
very usefull.

I'm now working on the access version. This project is made in C#. It's made
to do all the job alone. You should have to show where is the source on your
disk and it will do the rest. I first used the Oledb Provider, but, as I said
before, a method seems to be badly made (It's very amazing !!) and can't find
the "AllowDBNull" property if the current column is not a primary key, which
make the script useless.

The problem is that I discovered .NET framework for the first time two weeks
ago so I'm not very efficient. I would like a tools I can use in my C#
project directly if possible.

I'm making an ODBC provider version to see if it works better.

But as you are a MVP you should tell Microsoft the problem. I saw many post
about this subject in many different forums and none were solve despite many
MVPs looked at the problem.

Once again sorry for mistakes, if my question is not very clear ask me more
informations.