Results 1 to 2 of 2

Thread: Multiuser query

  1. #1
    Join Date
    Feb 2005

    Unanswered: Multiuser query

    Hi everyone. I have 2 problems:

    (i)I have developed a VB6 application that needs to connect to an Access database (residing on a shared network drive) to merely read a record fro a table. When an attempt is made from 2 different workstations there is an error 'Permission denied' generated. What can be wrong?

    (ii)Another VB6 application is also set up on a shared network drive. One of its functions is to get a copy of an Access database from another network drive and paste it to the 'local' workstation (I assume it is trying to copy to the application drive) and then extract data into a Word file. Each time multiple users attempt to do this at about the same time from different workstations, an error message such as 'Permission denied' or 'Path not found' appears BUT the process finishes up working because the Word file opens successfully on each machine with the relevant information. This confuses me. Why is an error message generated?

    Any help greatly appreciated


  2. #2
    Join Date
    Apr 2004
    metro Detroit
    Is there any security on the Access db?

    Is the vb code used to open the db opening it exclusively?

    What code are you using to copy the db to the local drive?
    Last edited by rogue; 02-24-05 at 09:20.

Posting Permissions

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