Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Chris Van de Velde
  Where is Chris Van de Velde?
 Chris Van de Velde
 To: valin banares
  Where is valin banares?
 valin banares
Subject: RE: Updating ACCESS database
Thread ID: 21683 Message ID: 21697 # Views: 22 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Sunday, March 30, 2003 10:20:52 AM         

> >
> > 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:

counter in status bar shows 1 record
counter in status bar shows 1 record
counter in status bar says NONE!!??
Chris Van de Velde