>Eric,
>
>I tried, but it dosen't work.
>
>This is how I have it now, do you see anything incorrect here?
>
>(General) (Declarations)
>Public ODBPath As New ADODB.Connection
>Public ODBPathTable As New ADODB.Recordset
>
>
>Private Sub Main()
>ODBPath.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Mode=Read|Write|Share Deny None;Persist Security Info=False;Data Source=" & curPath & "\setpath.mdb")
>
>ODBPathTable.CursorLocation = adUseClient ' Required for use of Sort property
>ODBPathTable.Open ("path"), ODBPath, adOpenDynamic, adLockOptimistic
>
>End sub
>
>I appreciate your help again.
As a knowledge base article says (
http://support.microsoft.com/support/kb/articles/Q229/7/41.ASP), remove the
mode> property of your connectionstring.
It should now read:ODBPath.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & curPath & "\setpath.mdb")
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com