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

[Krazy Katt]

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

--

 

[Krazy Katt]

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!

--

 

[Joseph Meehan]

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.