🚀 go-pugleaf

On Fri, 16 Jun 2000 14:07:36 +0200, "pepito perez" <pepito@hotmail.com>
wrote:

>I launch two different transactions from two clientes, one of them begins to
>insert registers into a table, the other one try to delete registers from
>the same table.
>
>The same proof works fine with SQL Server, but when I try it with Access the
>program gives me an "Access violation".
>
>Does Acess work well with transactions ?

I do not believe that MS-Access supports Database Transactions (at least
not through Access97 AFAIK).  MS-Access does try to provide most of the
same functionality as MS-SQL Server,  but there are a few areas where it
falls far short...

The "Access Violation" means that your program is attempting to reference
memory which it is not authorized to access.  This could be by referencing
through a NULL pointer (you should be able to trace back to that in the
debugger though).  If you look at the call-stack when you get your A-V
error,  you can tell where the error is happening.  It might be that you
are passing an invalid value to a VCL function, or that you are
accidentally referencing through a NULL pointer, or one of a number of
other issues.

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)