Recent content by WyoDave

  1. W

    Access 2010 INSERT locks SQL but works in Access 2000

    RX, Thanks for chiming in. I had tried that before but gave it one more try at your suggestion. Still can't get around the lock without closing the form. Moving on.
  2. W

    Access 2010 INSERT locks SQL but works in Access 2000

    Well I have finally given up on making Access 2010 run the original code the same as Access 2000. There is definitely a lock caused by a form but I can't find where. I ended up rewriting the logic to save a few pieces of data from the form, closing the form, running the process and finally...
  3. W

    Access 2010 INSERT locks SQL but works in Access 2000

    Static, Thanks for the reply. The original code does not have any .begintrans or .committrans in the code. I did try rewriting the code to use execute rather than DoCmd.RunSQL so that I could try adding the .begintrans and .committrans. Unfortunately this did not have any positive effect...
  4. W

    Access 2010 INSERT locks SQL but works in Access 2000

    Looking for some direction please. A little background first. We have a complex, but stable, Access 2000 front end and SQL 2005 backend. It has been determined that we need to upgrade to Access 2010. My initial testing is to attempt to run the .mdb using Access 2010. This allows me to run...
  5. W

    Hello from beautiful Wyoming, USA.

    I have formal software development training with 25+ years of experience and have been using MS Access since version 2.0. I have also been using MS Access with SQL for about 10 years.
See more
Top Bottom