none
Workgroup client connection fails when MS Access is open. RRS feed

  • Question

  • Hello all,

     

    I have two PCs on an Ethernet switch in the same Windows workgroup.

     

    The main PC has an unsecured MS Access database and a LabView client application.

     

    The 2nd PC has an identical LabView client application.

     

    I can connect to the MS Access database tables from the 2nd PC only when the MS Access application is not open on the main PC.

     

    All SQL database transactions work well.

     

    As soon as MS Access is opened on the main PC the 2nd PC cannot connect.

    No tables are being viewed or in design mode.

     

    It is as though MS Access has the database open exclusively.

    However, every MS Access exclusive selection is off and the shared selection is on.

     

    The LabView client application on the main PC has no trouble connecting while MS Access is open.

     

    The error returned to LabView:

     

    Exceprion occured in MS OLE DB Providor for ODBC Drivers.

    Could not use '(unknown)'; file already in use.

     

    I am using System DSN connections.

    There is no system.mdw security file.  Yet.

     

    Any ideas?

     

    thanks in advance for good advice.

     

    Ted

    Monday, August 18, 2008 9:03 PM

Answers

  • Are you using XP or Vista (or both) in the workgroup environment?

     

    In addition, you need to make certain that all users have full permissions to the folder where the database is located. I suspect there may be a permissions problem when the second PC needs to write to or read the corresponding .LDB file.

     

    Tuesday, August 19, 2008 4:09 PM

All replies

  • Try opening with 2 copies of Access on same machine, see if this works.

    MS Access will open exclusive by default unless you specifically choose otherwise.

     

     

     

     

     

     

    Tuesday, August 19, 2008 6:00 AM
  • Matt,

     

    I have selected the default open mode as shared.

    Default record locking as no locks.

    Open databases by using record-level locking.

     

    As you suggested I opend the database table with two instances of MS Access running on the main PC.

    LabView can connect to any of the database tables and all SQL transactions are performing as expected on the main PC.

    Even when MS Access is viewing the table.

    I can change values in MS Access and see the values update in LabView.

     

    The second PC cannot connect to the database table as long as MS Access is open.

     

    Is there a workgroup issue with MS Access?

     

    regards,

     

    Ted

    Tuesday, August 19, 2008 11:20 AM
  • Are you using XP or Vista (or both) in the workgroup environment?

     

    In addition, you need to make certain that all users have full permissions to the folder where the database is located. I suspect there may be a permissions problem when the second PC needs to write to or read the corresponding .LDB file.

     

    Tuesday, August 19, 2008 4:09 PM
  • Paul,

     

    I checked the file sharing of the directory that contains the database file and found that in the sharing tab the selection "Allow network users to change my files"  was unchecked.

     

    I am glad it was a mere oversight and not a Microsoft Access or network workgroup problem.

     

    cheers,

     

    Ted

     

     

    Tuesday, August 19, 2008 5:11 PM