>>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
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>