AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Lock record/tables in MS Access          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message VisionSet Guest Posted: Sat Jan 03, 2004 10:56 pm    Post subject: Lock record/tables in MS Access I do this: SELECT a Set of records from database compare this with another Set If they are the same I UPDATE, INSERT & DELETE to the database But I need to do these tasks with a locked table or series of records, to ensure no concurrent writes incur conflict. How can I achieve this in Access through JDBC-ODBC? I have read that I must get Access to do the locks rather than JDBC, but how do I instruct Access to do this? Or any other suggestions to achieve this goal? -- Mike W Back to top VisionSet Guest Posted: Sun Jan 04, 2004 12:57 am    Post subject: Re: Lock record/tables in MS Access "VisionSet" <spam (AT) ntlworld (DOT) com> wrote .... Quote: But I need to do these tasks with a locked table or series of records, to ensure no concurrent writes incur conflict. How can I achieve this in Access through JDBC-ODBC? I have read that I must get Access to do the locks rather than JDBC, but how do I instruct Access to do this? Or any other suggestions to achieve this goal? Actually I see now that I *can* use transactions to accomplish this. Thanks [email]marvinbbb (AT) yahoo (DOT) de[/email] for your reply to an earlier thread -- Mike W Back to top Silvio Bierman Guest Posted: Sun Jan 04, 2004 9:07 am    Post subject: Re: Lock record/tables in MS Access "VisionSet" <spam (AT) ntlworld (DOT) com> wrote Quote: "VisionSet" <spam (AT) ntlworld (DOT) com> wrote in message news:2IHJb.16232$526.108694 (AT) newsfep4-glfd (DOT) server.ntli.net... ... But I need to do these tasks with a locked table or series of records, to ensure no concurrent writes incur conflict. How can I achieve this in Access through JDBC-ODBC? I have read that I must get Access to do the locks rather than JDBC, but how do I instruct Access to do this? Or any other suggestions to achieve this goal? Actually I see now that I *can* use transactions to accomplish this. Thanks [email]marvinbbb (AT) yahoo (DOT) de[/email] for your reply to an earlier thread -- Mike W No you cant. Access has terrible multi-user behaviour with a broken locking scheme. It has no real transactional behaviour so the transaction APIs in JDBC will not do anything usefull for you. If you are doing more than single user data storage drop Access and look at something different (SQLServer, MySQL, ...) Silvio Bierman Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.