Hi
I am trying to determine the column names in a table in an access xp
database using c# in an asp.net web page.
I can determine the table names by reading the MSysObjects table.
The SQL system function COL_Name does not work with access.

Any suggestions would be appreciated.

Brain O'Haire

Hi Brian,

Check out OleDbConnection.GetOleDbSchemaTable method.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

"Brian O'Haire" <(E-Mail Removed)> wrote in message
news:uktwsF$(E-Mail Removed)...
> Hi
> I am trying to determine the column names in a table in an access xp
> database using c# in an asp.net web page.
> I can determine the table names by reading the MSysObjects table.
> The SQL system function COL_Name does not work with access.
>
> Any suggestions would be appreciated.
>
> Brain O'Haire
>
>
>
>

Hi Miha

That was just what I was looking for, thank you.

Brian O'Haire

"Miha Markic" <miha at rthand com> wrote in message
news:uhK5m1$(E-Mail Removed)...
> Hi Brian,
>
> Check out OleDbConnection.GetOleDbSchemaTable method.
>
> --
> Miha Markic - RightHand .NET consulting & development
> miha at rthand com
>
> "Brian O'Haire" <(E-Mail Removed)> wrote in message
> news:uktwsF$(E-Mail Removed)...
> > Hi
> > I am trying to determine the column names in a table in an access xp
> > database using c# in an asp.net web page.
> > I can determine the table names by reading the MSysObjects table.
> > The SQL system function COL_Name does not work with access.
> >
> > Any suggestions would be appreciated.
> >
> > Brain O'Haire
> >
> >
> >
> >
>
>