Records cannot be read error

[sbflood]

Hi there,

I have a split database where the backend is on a company server and about 15 people have their own copy of the frontend. I've made several field additions to the backend table over the last two weeks but yesterday I added two more fields and now the front end gives me the error: Record(s) cannot be read; no read permission on 'Unit Information'. Unit Information is the name of the table I added fields to.

I have compacted and repaired both the front and backends. When I go into the Linked Table Manager on the frontend, the Unit Information table is no longer listed. When I go to Navigation Options and check Show System Objects, Access completely crashes, closes and restarts.

An old copy of the frontend still works perfectly with the database and it writes/saves to the Unit Information table just fine. It's only when the old copy is compacted and repaired or if I manually update the table links that the issue above arises.

I don't understand how it could be a permissions issue if everyone has been and is still able to write to the database. How does adding two fields effect permissions and why didn't this happen the four other times I added fields to this table? Is this a corruption issue and if so, what are my options for restoring?

Thanks in advance!

 

[jdraw]

You haven't explicitly said that you refreshed the links to your revised linked tables.
When you add fields and/or tables to your backend, you have to re-link (refresh the links to) your backend tables. This has to be done from the front end (either manually or via code).
You really should be researching front-end auto updater. There are several mentioned in various forums.

Here are just a few:
see autoupdate
see Tony Toews
Bob Larson

 

[sbflood]

Right, I manually refresh the frontend links when I add fields, and it's worked fine before now.

The way I update other people's copy of the front end is with code that checks the version and if it's different, their copy will be deleted and replaced with the latest version. So I don't need an auto link refresher.