> >
> > 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
>
>
> Try this after the insert command
> >>>CURSORSETPROP("Buffering", 5, "tablename")
> >>>Tableupdate(.t.)
> >>>
>
> Hope it will help.
> The more you know... The more you do not know...

Same result as ever:

USE TABLENAME
INSERT.....
counter in status bar shows 1 record
CURSORSETPROP...
TABLEUPDATE
counter in status bar shows 1 record
USE
USE TABLENAME
counter in status bar says NONE!!??
Chris Van de Velde