>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;"
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com