Determine table names and column names in Access database

  • Thread starter Thread starter Brian O'Haire
  • Start date Start date
B

Brian O'Haire

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.
 
Hi Miha

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

Brian O'Haire
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
XML and SQL database 3
Copying from SQL Server database to Access and Vice versa 0
temporary work files showing up in getoldDbSchemaTable call 2
Using LINQ to SQL with multiple databases 1
Access Deleted Table after Compact and Repair Database (Access 2010) 0
Access stripping decimal places in query 1
Cannot access foreign database Msysobjects - No read rights 2

Back
Top