exclusively open, locking the database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Saiyou Anh
    #1

    exclusively open, locking the database

    Hi! Please help:
    We have an Access application, using linked SQL server tables, on
    network. After moving to a new server, the access file is always
    crashed, sometimes the system table (Msysmodules2) exclusively opened
    by another user (but the default open mode is Share), sometimes the
    file is not recognized as Access file. Every time when that happened,
    I have to copy the file from my C drive to the network to solve the
    problem, but half day later, that happened again. The network people
    don't think this is a server problem. What that could be?
    Thanks!
    Saiyou
    Tags: None
    • MacDermott
      #2
      Re: exclusively open, locking the database

      One possibility is a faulty network card on the new server.
      Access is more sensitive than other applications, so it can fail when other
      applications seem to work fine.
      Ask your network people to put a "sniffer" on the server's network card.

      HTH
      - Turtle

      "Saiyou Anh" <wangc@alexian. net> wrote in message
      news:a51d3ca7.0 406221145.7a9c5 0cb@posting.goo gle.com...[color=blue]
      > Hi! Please help:
      > We have an Access application, using linked SQL server tables, on
      > network. After moving to a new server, the access file is always
      > crashed, sometimes the system table (Msysmodules2) exclusively opened
      > by another user (but the default open mode is Share), sometimes the
      > file is not recognized as Access file. Every time when that happened,
      > I have to copy the file from my C drive to the network to solve the
      > problem, but half day later, that happened again. The network people
      > don't think this is a server problem. What that could be?
      > Thanks!
      > Saiyou[/color]


        Comment

        • paii, Ron
          #3
          Re: exclusively open, locking the database


          "Saiyou Anh" <wangc@alexian. net> wrote in message
          news:a51d3ca7.0 406221145.7a9c5 0cb@posting.goo gle.com...[color=blue]
          > Hi! Please help:
          > We have an Access application, using linked SQL server tables, on
          > network. After moving to a new server, the access file is always
          > crashed, sometimes the system table (Msysmodules2) exclusively opened
          > by another user (but the default open mode is Share), sometimes the
          > file is not recognized as Access file. Every time when that happened,
          > I have to copy the file from my C drive to the network to solve the
          > problem, but half day later, that happened again. The network people
          > don't think this is a server problem. What that could be?
          > Thanks!
          > Saiyou[/color]

          Is the Access file the Front-end? If so each user should have a private
          copy.
          Also, is the new sever a Windows server?


            Comment

            Previous template Next
            Working...