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

K

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

--
 
K

Krazy Katt

Krazy said:
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
Click to expand...

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!

--
 
Top