ok. Thanks...

but it was running fine on MS Access db until I convert it into MS SQL Server...how come?

Sushila, thanks for your help. I've resolved it by using DSN connection string.

I've gone through that, but my RDC over ODBC is still having same error...

My application is running on MS SQL Server 7 with...

Thanks so much sushila. I works fine as it extracts the primary key from the SQL tables.

However, after I review the overall objective of my VB project, I found...

David,

I've read about the re-link Access database with SQL database. But I have no idea about DTS solutions. Could you please elaborate more or show me the referencing URL relating to...

You mean u did upsize all your queries? into stored-procedures?