1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel/Access 2003 Issue

Discussion in 'Business Applications' started by WT1059, Apr 8, 2010.

Thread Status:
Not open for further replies.
  1. WT1059

    WT1059 Thread Starter

    Joined:
    May 13, 2009
    Messages:
    60
    I have a tool that I inherited with the job and have to support which involves an Excel Spreadsheet over an Access Database using ADO. The Excel Spreadheet is located on the users (about 30 total users) desktop and the Access Database it located on a Network Drive. The origional setup used drive mapping but I updated it to use the UNC path and made a great gain in the speed of the data flow. The tool is used for lobby control and gathering metrics about the clients they are seeing. So a client comes in and is entered into the database by a clerk at the front desk. Then a specialist will open their Spreadsheet and click the Find Next Client button to select the client.

    For the most part I don't have any problems with the tool. It runs well and I have updated it giving the users more functionality. However I do have 1 issue that I just can't seem to fix. There is 1 column where the data for an entry, once selected by a specialist will be overwritten by another specialist and that specialist will try to call back a client that is already being assisted. I have tried to prevent this from happening within the spreadsheet but nothing Ive done works. Is there any way of locking the data in this column down within Access once it is entered so that another specialist cannot select a client already selected? Very fustrating for the users.

    Thanks
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Have you looked at the Database Main Menu>Tools>Options>Advanced>Default Record Locking and set it to "Edited Record".
     
  3. WT1059

    WT1059 Thread Starter

    Joined:
    May 13, 2009
    Messages:
    60
    No, it was set to No locks. I changed it and will see what happens. Thanks for the reply.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/915591

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice