Here is my ODBC view:
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only