I am looking for a sp_Columns like function for Access

R

rlawson

I need to have Access through ODBC return a table
containing a table structure. SQL Server has sp_Columns
and FoxPro has Copy Structure (Extended).

Does anyone know how to do this in Access using VB 6.0 and
ADO?
 
M

Michel Walsh

Hi,


You can use the ADO Schemas... This is assumed to be the uniform way to
access those info, independently of the db engine. See, as example, "ADO 2.6
Programmer's Reference", Sussman, WROX, Appendix D.



Hoping it may help,
Vanderghast, Access MVP
 

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

Looking for Information Word (Office 365) editing using VB.Net 1
Using "like" query from and external link to Access 1
Using "like" from an external link 1
Importing FoxPro 2.6 DBF Into Access 2007 1
Transfering Data 4
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Spreadhseet import using DoCmd.TransferSpreadsheet fails 6
Access 2003 and SQL Server 2005 and DAO recordset 1

Top