Table access

[sturner333]

I have a front-end database that is linked to a back-end. The back-end is a
replica. I recently re-did the back-end, added some tables. I have never had
this problem before when I have had modifications but the following happens
now:

I can refreash the link between the front-end and back-end and the database
starts and works ok. When I get out of the database and then re-enter, I get
the message 'Run-time error 3112: Record(s) cannot be read, no read
permission.
This happens every time until I refreash the links and then it again only
works once.

I have 'compact\repaired'. Any advice?
Thanks

 

[John W. Vinson]

I have a front-end database that is linked to a back-end. The back-end is a
replica. I recently re-did the back-end, added some tables. I have never had
this problem before when I have had modifications but the following happens
now:

Did you synchronize the replicas? If it's a single backend... why replicate?
Where are the replicas?

I can refreash the link between the front-end and back-end and the database
starts and works ok. When I get out of the database and then re-enter, I get
the message 'Run-time error 3112: Record(s) cannot be read, no read
permission.
This happens every time until I refreash the links and then it again only
works once.

I have 'compact\repaired'. Any advice?
Thanks

Two quick things to check: do you have full Windows security read, write,
create and delete permission on the folder containing the backend? And have
you implemented Access workgroup security - and do you have read permission on
all the tables (including the replication tables and system tables)?

John W. Vinson [MVP]