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?)