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

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'.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6795-record-s-cannot-read-no-read.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6795

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

--

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6795
> (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!

--
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6795

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6795
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6795
end has not had its file attributes changed to read only.

--
Joseph Meehan

Dia duit