Welcome to SPN

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

Sign Up Now!

Record(s) cannot be read; no read permissions on 'table'. after splitting database

Discussion in 'Information Technology' started by Krazy Katt, Nov 6, 2005.

  1. Krazy Katt

    Krazy Katt
    Expand Collapse
    Guest

    Hi,

    I am using Access 2002 with a 30 Meg database that was originally
    written for Office 97. Anyways the database has been converted
    to 2002 and ran fine until I decided to split it using
    Access' 'Split Database' feature. I stored the new backend
    and frontend in the same directory. I have no problem directly
    accessing the linked backend tables from the frontend, but
    whenever I open some object that accesses one of the tables
    (whether it's a form, or a query) I get the following error

    Record(s) cannot be read; no read permissions on 'table'.

    Can anyone help me to resolve this problem? I'd like to
    split the database so that it can be shared by several
    machines and I can't find anything on the web. I've tried
    splitting it several times, but always the same result.

    Thanks!

    Thanks

    --
     
  2. Loading...

    Similar Threads Forum Date
    Cannot Find A Thread ? Try "Search by Tag." Announcements Jan 21, 2013
    I cannot Keep My Hair No Longer Sikh Youth Aug 8, 2012
    India Govt cannot change purpose of acquired land: SC Breaking News Oct 6, 2011
    USA TSA: Body Scanners Cannot See Through Turbans Breaking News Jan 14, 2011
    India India cannot help but be complex Breaking News Oct 2, 2010

  3. Krazy Katt

    Krazy Katt
    Expand Collapse
    Guest

    Krazy Katt wrote:

    > Hi,
    >
    > I am using Access 2002 with a 30 Meg database that was originally
    > written for Office 97. Anyways the database has been converted
    > to 2002 and ran fine until I decided to split it using
    > Access' 'Split Database' feature. I stored the new backend
    > and frontend in the same directory. I have no problem directly
    > accessing the linked backend tables from the frontend, but
    > whenever I open some object that accesses one of the tables
    > (whether it's a form, or a query) I get the following error
    >
    > Record(s) cannot be read; no read permissions on 'table'.
    >
    > Can anyone help me to resolve this problem? I'd like to
    > split the database so that it can be shared by several
    > machines and I can't find anything on the web. I've tried
    > splitting it several times, but always the same result.
    >
    > Thanks!
    >
    > Thanks


    Found a solution -- for whatever reason the frontend did not have
    permission to access the backend tables, so I imported all the objects
    in the frontend into a new database and wouldja believe it? Problem
    gone.

    If anyone knows why this would happen I'd love to know simply for my
    self edification.

    Thanks!

    --
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Krazy Katt wrote:
    > Hi,
    >
    > I am using Access 2002 with a 30 Meg database that was originally
    > written for Office 97. Anyways the database has been converted
    > to 2002 and ran fine until I decided to split it using
    > Access' 'Split Database' feature. I stored the new backend
    > and frontend in the same directory. I have no problem directly
    > accessing the linked backend tables from the frontend, but
    > whenever I open some object that accesses one of the tables
    > (whether it's a form, or a query) I get the following error
    >
    > Record(s) cannot be read; no read permissions on 'table'.
    >
    > Can anyone help me to resolve this problem? I'd like to
    > split the database so that it can be shared by several
    > machines and I can't find anything on the web. I've tried
    > splitting it several times, but always the same result.
    >
    > Thanks!
    >
    > Thanks


    You need to make sure the user has full read write edit and delete
    authority to the directory where the back end is located and that the back
    end has not had its file attributes changed to read only.

    --
    Joseph Meehan

    Dia duit
     

Share This Page