>
> I want to update an ACCESS database from withing VFP 7. I have created an ODBC entry (user level), created a VFP database, with a connection to the ACCESS ODBC.
> When I update the database (interactively or with a .prg) all seems to work fine, as long as I do not close the view or the database. When I reopen, all my modifications are gone. It seems that the updates and inserts get done, but never committed (allthough tried buffering and transactions) and a rollback takes place on the close.
> Any help would be apreciated
> Chris Van de Velde

did you make the views updateable.

Boudewijn Lutge®ink
Boudewijn.Lutgerink@foxite.com
Experience is the knowledge you get immediately AFTER you actually needed it...