By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Read PK from MS Access Metadata

P: n/a
Hey,

when I open an ado-connection from a dsn that is linked to an MS Access
database and I use the openSchema method (adSchemaPrimaryKeys), I've
got the following error (-2146825037):"
Exception occured in ADODB.Connection, Object or provider is not
capable of performing requested operation.. Help Path is
C:\WINNT\HELP\ADO270.CHM and context 1240648

The strange thing is, that when I open the connection on the udl way
(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\database.mdb), I can
read the schema without any problems

How can I open read the primary key's from an Access database, with a
dsn-connection (are there some sys-tables like sql-server or
information_schema where I can query from?)

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.