>I created a test PRG wi3 3 lines:
>
>cTable = "test.mdb"
>oAccess = CREATEOBJECT("Access.Application")
>oAccess.DoCmd.OpenTable(cTable)
>
>When I run it, I get an OLE Error:
>
>"You can't carry out this action at the present time"
>
>
>what gives? anyone know? I'm trying to open an Access table and
>read data back into VFP.
>
>Thanks
I'm not sure there's any advantage to using automation here.
Your best bet would be to use SQL PassThrough or a remote view, using an ODBC connection into the Access Database.
If you need to code the creation of the ODBC connection, see MSKB#
Q142216.
Insanity: Doing the same thing over and over and expecting different results.