Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Angry Unanswered: migrating with from access with VB scripts

    The company i am working for has been using an Access database for purchasing and inventory. this has become to small/dangerous due to the number of records and frequent 'database needs repair' errors. I am trying to migrate the database to a sql server w/ access front end and am runing into problems with most of the VB proceedures that are built into the database. the most common at the moment is a 'Write Conflict' error saying someone else changed the record i am editing. i know this can't be the case becasue i am working on this in an isolated environment. I have traced it to a VB script that changes a field from 'Entering' to 'Pending' (text field) on the click of the 'new record' button. any ideas?

    Access 2000/2003, SQL server 2000

  2. #2
    Join Date
    Oct 2003
    Posts
    706

    Lightbulb

    If you have more than one channel open to the database server (a second "session", basically) then that may well appear to be "another user."
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    doesn't seem to be, in my tracing, the issue seems to be that VB doesn't know that I'm the person makeing the changes. It looks like the VB script starts when the form opens, checks the contents of the record to be worked on and when the button is clicked, finds the contents have changed.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Please post the code involved.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •