Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: valin banares
  Where is valin banares?
 
 Philippines
 valin banares
 To: Chris Van de Velde
  Where is Chris Van de Velde?
 antwerpen
 Belgium
 Chris Van de Velde
 Tags
Subject: RE: Updating ACCESS database
Thread ID: 21683 Message ID: 21684 # Views: 31 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Saturday, March 29, 2003 2:29:40 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...

COMPLETE THREAD

Updating ACCESS database Posted by Chris Van de Velde @ 3/29/2003 1:13:33 AM
RE: Updating ACCESS database Posted by valin banares @ 3/29/2003 2:29:40 AM
RE: Updating ACCESS database Posted by Chris Van de Velde @ 3/30/2003 10:20:52 AM
RE: Updating ACCESS database Posted by Boudewijn Lutgerink @ 3/30/2003 5:28:30 PM
RE: Updating ACCESS database Posted by Troy Reganall @ 4/2/2003 7:35:06 PM