Is that same dbf opened exclusively anywhere else?
Are you using VFP OLEDB Provider to connect or just ODBC datasource?
The reason why I asked because I saw some threads on other newsgroups having problems connectiong to Free table using VFP OLE DB?
>Hi everyone
>
>I'm connecting to a DSN without any error(s) through
>
>Set Conn = Server.CreateObject("ADODB.Connection")
>Conn.Open("dsn=DataSource")
>
>However the command
>
>sql = "Select * from personal"
>set rs = Conn.Execute(sql)
>
>This SQL statement works locally but not as shown above.
>
>The error looks like this:
>
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC Visual FoxPro Driver]Cannot open file e:\domains\bcthis.co.uk\user\private\personal.dbf.
>
>
>I’ll appreciate any hints to execute the SQL statement correctly.
>
>Oscar Corte
- Jayesh