DB Transactions with Access

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by pepito perez Fri, 16 Jun 2000 00:00

#1093

Author: pepito perez
Date: Fri, 16 Jun 2000 00:00

10 lines
867 bytes

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 ?

Thank you in advanced.

Re: DB Transactions with Access

#1097

Author: Jerry Bloomfield (TeamB)
Date: Sun, 18 Jun 2000 00:00

31 lines
2008 bytes

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads