>Hi Eric,
>
> Yes, i have tried the code with NWind database.
>
> can i connect access through DSN method. pls tell me the code.

The best way to know what the connection string is is to use the data environment or a ADO data control to create your connection string. Once created you just have to cut-and-paste it to your code!