Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Problem getting database to work on other PCs

Discussion in 'Information Technology' started by Nicholas Scarpinato, Nov 12, 2005.

  1. Nicholas Scarpinato

    Nicholas Scarpinato
    Expand Collapse
    Guest

    Hi. I have a couple of databases that I'm creating for some other people in
    the office, and everything works fine as long as I run the DB from my PC. But
    as soon as I try to run it from their PC, I get the message "Can't update.
    Object is read only." Both of these DB's import text files off a network
    drive as part of their primary function (they import a file, add some numbers
    up, format the file correctly for uploading to our mainframe, then export the
    data). I don't understand the holdup, none of my other DB's have been doing
    this to anyone. Any ideas?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

  3. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    Have you added Access Security to the db's? Where are the db's located, on
    the local drive or a network share? If on a network share, what are the
    user's permission on the share? If the share is on an NTFS drive, what are
    the user's permissions in the NTFS? How many users are accessing the same db
    file?

    --
    Wayne Morgan
    MS Access MVP


    "Nicholas Scarpinato" <NicholasScarpinato@discussions.microsoft.com> wrote
    in message news:4BDF7A40-DF43-4D7D-B8FE-65B9300D320B@microsoft.com...
    > Hi. I have a couple of databases that I'm creating for some other people
    > in
    > the office, and everything works fine as long as I run the DB from my PC.
    > But
    > as soon as I try to run it from their PC, I get the message "Can't update.
    > Object is read only." Both of these DB's import text files off a network
    > drive as part of their primary function (they import a file, add some
    > numbers
    > up, format the file correctly for uploading to our mainframe, then export
    > the
    > data). I don't understand the holdup, none of my other DB's have been
    > doing
    > this to anyone. Any ideas?
     
  4. Nicholas Scarpinato

    Nicholas Scarpinato
    Expand Collapse
    Guest

    > "Wayne Morgan" wrote:

    > Have you added Access Security to the db's?

    No.

    > Where are the db's located, on the local drive or a network share?

    I have put them on network drives and on local drives, both with the same
    result.

    > If on a network share, what are the user's permission on the share?

    We all have the same permissions on the network drive for our department, we
    have full access to all but 4 or 5 directories. I can run the database off
    the network drive perfectly fine, but nobody else can.

    > How many users are accessing the same db file?

    Just one at a time.

    Hope that helps clarify things.
     
  5. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    In that case, could the problem be with access to the text files you're
    importing or the location you're exporting to when you're done? How did you
    copy the file to the other computers? If you used a CD or other type of read
    only device, the read only attribute may have gotten copied along with the
    file. If so, you'll need to right click the file in Explorer, choose
    Properties, and clear the Read Only attribute.

    --
    Wayne Morgan
    MS Access MVP


    "Nicholas Scarpinato" <NicholasScarpinato@discussions.microsoft.com> wrote
    in message news:89C76914-71E1-4214-9BC6-FF8144CCDC70@microsoft.com...
    >> "Wayne Morgan" wrote:

    >
    >> Have you added Access Security to the db's?

    > No.
    >
    >> Where are the db's located, on the local drive or a network share?

    > I have put them on network drives and on local drives, both with the same
    > result.
    >
    >> If on a network share, what are the user's permission on the share?

    > We all have the same permissions on the network drive for our department,
    > we
    > have full access to all but 4 or 5 directories. I can run the database off
    > the network drive perfectly fine, but nobody else can.
    >
    >> How many users are accessing the same db file?

    > Just one at a time.
    >
    > Hope that helps clarify things.
     
  6. Nicholas Scarpinato

    Nicholas Scarpinato
    Expand Collapse
    Guest

    I'll have to check on that again, I checked the database through Access, but
    it didn't show any read-only attributes. I forgot to look at the actual .mdb
    in Explorer, lol. I guess that will have to wait until Monday.

    "Wayne Morgan" wrote:

    > In that case, could the problem be with access to the text files you're
    > importing or the location you're exporting to when you're done? How did you
    > copy the file to the other computers? If you used a CD or other type of read
    > only device, the read only attribute may have gotten copied along with the
    > file. If so, you'll need to right click the file in Explorer, choose
    > Properties, and clear the Read Only attribute.
    >
    > --
    > Wayne Morgan
    > MS Access MVP
    >
    >
    > "Nicholas Scarpinato" <NicholasScarpinato@discussions.microsoft.com> wrote
    > in message news:89C76914-71E1-4214-9BC6-FF8144CCDC70@microsoft.com...
    > >> "Wayne Morgan" wrote:

    > >
    > >> Have you added Access Security to the db's?

    > > No.
    > >
    > >> Where are the db's located, on the local drive or a network share?

    > > I have put them on network drives and on local drives, both with the same
    > > result.
    > >
    > >> If on a network share, what are the user's permission on the share?

    > > We all have the same permissions on the network drive for our department,
    > > we
    > > have full access to all but 4 or 5 directories. I can run the database off
    > > the network drive perfectly fine, but nobody else can.
    > >
    > >> How many users are accessing the same db file?

    > > Just one at a time.
    > >
    > > Hope that helps clarify things.

    >
    >
    >
     

Share This Page