I'm having to work with Term Master, which looks like it stores it's data in
a Clipper Database files since Clipper is what used NDX as Index files.   I
know how the connection would look, but I'm unsure how to access the DBF
file from ADO.

set objConnAccess = Server.CreateObject("ADODB.Connection")
objConnAccess.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\cashworks-srv2\CWI2$;Extended Properties=dBASE IV;User
ID=Admin;Password="

Now how do I say "USE Database"?  Do I use it like an Execute statement?
set objRS = objConnAccess.Execute("USE DatabaseName")

or what?

Can I use "SELECT * FROM dBaseName" ??

Direction please..

Thanx

Nevermind..  Figured it out..

"SELECT * FROM dBaseName" worked..


"Gavin Landon" <glandon@g...> wrote in message
news:203803@a..._databases...
>
> I'm having to work with Term Master, which looks like it stores it's data
in
> a Clipper Database files since Clipper is what used NDX as Index files.
I
> know how the connection would look, but I'm unsure how to access the DBF
> file from ADO.
>
> set objConnAccess = Server.CreateObject("ADODB.Connection")
> objConnAccess.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=\\cashworks-srv2\CWI2$;Extended Properties=dBASE IV;User
> ID=Admin;Password="
>
> Now how do I say "USE Database"?  Do I use it like an Execute statement?
> set objRS = objConnAccess.Execute("USE DatabaseName")
>
> or what?
>
> Can I use "SELECT * FROM dBaseName" ??
>
> Direction please..
>
> Thanx
>
>
>
>