access runtime locks Carol 01.08.2006 16:08:03 I have developed an access runtime application in 2003 Developer (XP) that is looking at a database on a server and being used by multible users as an inquiry only. I am getting "Locks" on the server and when this happens nobody can get in. Most of the users are on Office 2000. I am using Office XP. Seems like the locks come when I get in the database. Also a another problem a few users have the full version of access and the runtime and when they go in to explorer and open up an access database it defaults to the runtime version instead of the full access. When I do it, it defaults to the full version. We have tried to use the "Open with..." and default to the full version, but does not work. Is all of these problems a conflict of 2000 vs 2003.

Re: access runtime locks "Albert D. Kallal" <PleaseNOOOsPAMmkallal[ at ]msn.com> 03.08.2006 05:26:34 [Quoted Text] > Is all of these problems a conflict of 2000 vs 2003. Well, as a general rule, if you do run a mixed environment, then you should either create the mde in a2000, and distribute that to each pc, or perhaps (more work), distribute a mde to each machine based on the SAME version of ms-access. Your back end data (the part on the server) will obviously have to remain in a2000 format so both a2000, and a2003 can use the application. So, splitting likely would fix a lot of problems for you. As for "getting locks" on the server, it is not quite clear what you mean. Anyway, to learn about splitting, you can read the following..as it explains not only that you should split, but WHY you split... http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm -- Albert D. Kallal Edmonton, Alberta Canada pleaseNOOSpamKallal[ at ]msn.com