PDA

Click to See Complete Forum and Search --> : DataBase - Foxpro


danab
Jan 10th, 2000, 10:42 PM
Does DAO support foxpro as a Database??
I konw the commands needed to connect to an ms access database.
Are the commands for Foxpro the same??
Thanks.
Dan.

Crazy D
Jan 10th, 2000, 10:53 PM
Doesn't have the DAO control a connection string builder? (if you drop the ADO recordset control on a form, you can build a connection string with that, copy it to your source and ready (at least that's the way i build my connectionstring...)

danab
Jan 10th, 2000, 10:58 PM
What???
All I want to do is somthing like:
set db=opendatabase("FoxProDatabase")
srt rs=db.openrecordset("MyTable")
ETC........
Is this possible??

LG
Jan 11th, 2000, 12:18 AM
Hi,danab!

I believe there is a sample code you are looking for.
http://support.microsoft.com/support/kb/articles/q161/3/07.asp

Larisa

HarryW
Jan 11th, 2000, 11:39 AM
Maybe you could just import your foxpro DB into an Access table. Just an idea.

I'm not sure about DAO, but I know that in my A-Level coursework I used a dBASE database in VB. Foxpro's more or less the same, isn't it? I think I remember it being on the list of database types you could connect straight to a data control.