My Dear,
It's working fine now... thank you very much.....

but you didn't tell me why I should use .Jet.OLEDB.3.51 insted of ...4.0 ?



>>>>Yes.. but the problem solved when i made a data link connection.
>>>>but now it is giving error on the .Open line as follow:
>>>>
>>>>Public Sub main()
>>>> 'This will open a global connection
>>>> Set gobjconn = New ADODB.connectoin
>>>> With gobjconn
>>>> ' Change the data source properth in the following time
>>>> .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\mysystems\res\res-test.mdb;Persist Security Info=False"
>>>> .Open <<<<==========
>>>> End With
>>>>
>>>> ' Now that the connection is open, display the application
>>>> Form1.Show
>>>>
>>>>Error Expr.
>>>>Runtime error 3709
>>>>the application requested an operation on an object with reference to a closed or invaled connection object.
>>>
>>>Is this a copy-and-paste from your application? If so, you have a serious typo error:

Set gobjconn = New ADODB.connectoin

>>>Should read

Set gobjconn = New ADODB.connection

>>>
>>>Also, you may want to try to set your provider to "Provider=Microsoft.Jet.OLEDB.3.51;"
>>
>>I fixed the type error, but still getting the same error, then i created a new
>>project and cut-and-paste what you sent me, but still getting the same error.
>>
>>So sorry for troubling you ...
>>Regards
>
>Can you create a small test (using nwind.mdb or biblio.mdb) and copy complete code here so I can test it!