>Hi
>I have established a connection to Access database using SQLConnect(). SQLTable() and SQLColumns() are working.
>I would like to get primary key from MS Access database like we do EXEC sp_pkeys @table_name = 'Table_Name'" in SQL Server.
>Any idea how to do this?

You can try

select @@identity

You should get the Autonumber field of the record you just inserted.

It works for me in Vb.net using ado.net. I connect via oledb, not sure how relevant that is.