Security issue - problem with permissions stripped off

  • Thread starter Thread starter \Bill Mayes via AccessMonster.com\
  • Start date Start date
B

\Bill Mayes via AccessMonster.com\

Data Entry Form access is corrupted. Multi-users attempting to input new
records when clicking on new record get error stating "unable to open
existing page". I cannot correct this problem. Forced to restore entire
database from a backup copy, losing all data entry previously done. Also,
when attempting first to Compact and Repair, the permissions are totally
stripped away from the same tables over and over again, and I cannot reset
them, even though I am the admin.
Any help out there?

Bill
 
"Bill Mayes via AccessMonster.com" said:
Data Entry Form access is corrupted. Multi-users attempting to input new
records when clicking on new record get error stating "unable to open
existing page". I cannot correct this problem. Forced to restore entire
database from a backup copy, losing all data entry previously done.
Click to expand...

There could be just about anything wrong, but here are a couple of things to
consider for starters:

1 - Is your app split into front/back ends?
2 - If so, do all your users have their own copy of the front end?
Also,
when attempting first to Compact and Repair, the permissions are totally
stripped away from the same tables over and over again, and I cannot reset
them, even though I am the admin.
Any help out there?
Click to expand...
What permissions? Have you applied user-level security? More info needed.

Regards,
Keith.
www.keithwilby.com
 
If you think your db is corrupted, & you do not want to restore the
last backup, the //first thing// you should do is to close the bad db &
take a copy. Then, if all else fails, you can send the copy to a data
recovery service. If you only have /one/ of the bad db, & you compact &
repair it, & that makes it worse, then - you're hosed!

If restoring the backup was significantly inconvenient, you may need to
review your backup frequency; eg. take it daily instead of weekly, or
whatever.

Can't comment on: "permissions are totally stripped away from the same
tables over and over again". You'd need to be clearer on what you mean,
What tables? Which permissions? What do you mean by "stripped away" &
how are you telling that? How are you selecting the right workgroup
file?, & so on.

HTH,
TC
 
Back
Top