Make sure that there is no buffering with=CURSORSETPROP("Buffering",0) -or-
make sure you issue a TABLEUPDATE(2,.T.) before closing the table.
>
>OPEN DATA dbc
>CREATE SQL VIEW TWCView;
> CONNECTION TWCustomers SHARE;
> AS SELECT * FROM access.customer
>
>I make changes but they are only saved to the local temp table, not to the actual connected Access database? I thought you could write to the file to?
>
>>Kevin ---
>>
>>Well...Not many, really, if you're just appending records.
>>
>>
>>>Ok, great, just got an ODBC view into an Access database. I have heard that performance with ODBC is pretty bad. If I am just appending records to an ODBC database once a night, I take it performance isn't really an issue. What database functions are hindered with ODBC.
>>>
>>>>It can read/write them as remote views via ODBC. There is no native use of Access databases.
>>>>
>>>>>Does VFP 6.0 import and export to Access databases? Or even better, will it write and read directly to an Access database?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05