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?
 antwerpen
 Belgium
 Chris Van de Velde
 To: valin banares
  Where is valin banares?
 
 Philippines
 valin banares
 Tags
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:

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

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