🚀 go-pugleaf

Thanks I will try what you suggested, but in searching the internet to
resolve this problem I cam across a Microsoft fix for this problem as it is
a problem with the JET engine. To fix this problem you need to install SP8
for MS Jet Engine.

Nigel

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:40b7088b$1@newsgroups.borland.com...
> ADO writes changes immediately. Try to add primary key to every table that
> you are using.
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Nigel" <nhussey@absamail.co.za> �������/�������� � �������� ���������:
> news:40b62c78@newsgroups.borland.com...
> > Hi All,
> > I am using a MSAccess database.  I connect to the database using
> > ADOConnection (CB6).  The broblem that i am experiancing is that quite
> often
> > my application reports an error when editing a record something in the
> likes
> > of "Another user has made changes to ths record" (not being used as a
> > multi-user application).  The only way around this is refreshing the
table
> > but this can take time.  Is there a connection method that will instruct
> > ADOTables to write changes immediatly to the underlying table.
> > P.S. I am not using cached updated.
> >
> > Thanks
> > Nigel
> >
> >
>
>