Not sure, but I don't believe Access is designed for transactions in particular.
Regardless,
though, try SAP DB (www.sapdb.org) for Windows 2K - it is a solid, transaction
supporting,
commercial grade free database with a type 4 JDBC driver. My consultancy does ETL and
enterprise
data strategies - lots of people and companies, large and small, like to keep mission
critical
data in Access databases because it is easy to use. It causes more trouble than its
worth in the
long run. So my advice is: use one of the free databases for your development purposes
(And
production, too!). Get a copy of SQL Server if you want to use a MS product that
supports
transactions well.
--- ±èÅÂȯ <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED]
>
> I am developing on ORION & WIN2k & tiny DB (Access2000)
>
> I tested Transactions in Access
>
> (con.setAutoCommit(false);con.commit();con.rollback();.....)
>
> Everything went well..
>
> But, Orion Setting makes Problem.
>
> in data-source.xml
> <data-source class="com.evermind.sql.DriverManagerDataSource"
>location="jdbc/AccessCoreDS"
> connection-driver="sun.jdbc.odbc.JdbcOdbcDriver" ejb-location="jdbc/AccessDS"
> xa-location="jdbc/AccessXADS" name="Access" password="7098" url="jdbc:odbc:oriondb"
> inactivity-timeout="30" username="neosuper" pooled-location="jdbc/AccessPool"/>
>
>
> This code works well, but if class attribute is changed to
> com.evermind.sql.DriverManagerXADataSource,
>
> Orion will not start with not founded Source Location Errors..
>
>
> Can't I use Transactions with Access 2000 ?
>
> Please give me some advices...... and solutions
>
> [EMAIL PROTECTED]
>
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
