Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / June 2006

Tip: Looking for answers? Try searching our database.

Permissions for one form changed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob Darlington - 14 Jun 2006 01:11 GMT
I have an Access 2002 application with approx 170 forms.
Security permissions are controlled via the back end tables.
In the front end (mde), the 'Users' group has access to all forms.
Yesterday, a client advised that she could not access one form. On checking,
I found that all 'Users' group permissions had been removed  for that form
and that form only.
My backups indicate that the change occurred in the last 2 days, and
occurred in my master copy of the front end as well as the distributed mde,
so it wasn't anything the client had done.
Has anyone else experienced similar problems? Could it be a result of a
corruption on the form?
Everything else seems to be working on the form.

Signature

Bob Darlington
Brisbane

Arno R - 14 Jun 2006 18:49 GMT
Did you have corruption issues ? and because of that
did you do something as SaveAsTxt <> SaveFromTxt ?

Arno R

>I have an Access 2002 application with approx 170 forms.
> Security permissions are controlled via the back end tables.
[quoted text clipped - 8 lines]
> corruption on the form?
> Everything else seems to be working on the form.
Bob Darlington - 15 Jun 2006 08:45 GMT
Arno,
Thanks for your reply, but no, I've not had any corruption issues (unless
this is one).

Signature

Bob Darlington
Brisbane

Did you have corruption issues ? and because of that
did you do something as SaveAsTxt <> SaveFromTxt ?

Arno R

"Bob Darlington" <bob@dpcmanAX.com.au> schreef in bericht
news:448f5439$0$20683$afc38c87@news.optusnet.com.au...
>I have an Access 2002 application with approx 170 forms.
> Security permissions are controlled via the back end tables.
[quoted text clipped - 10 lines]
> corruption on the form?
> Everything else seems to be working on the form.
Arno R - 15 Jun 2006 09:36 GMT
> Arno,
> Thanks for your reply, but no, I've not had any corruption issues (unless
> this is one).

Bob,
You said this:

> My backups indicate that the change occurred in the last 2 days, and
> occurred in my master copy of the front end as well as the distributed mde,

This means that these changes occurred *without* distributing a new mde ???
Sounds like magic to me, unless there is code inside the app that makes the changes.

Arno R.
Bob Darlington - 16 Jun 2006 01:54 GMT
Arno,
I have no code to change permissions on one form in the front end.
The mde was only mentioned to show how the app was deployed. It's not really
relevant to the problem (sorry I mentioned it).
In view of the lack of responses from anyone with similar experience, I
guess we come back to some type of  corruption on this one form.

Signature

Bob Darlington
Brisbane


"Bob Darlington" <bob@dpcmanAX.com.au> schreef in bericht
news:4491102f$0$11992$afc38c87@news.optusnet.com.au...
> Arno,
> Thanks for your reply, but no, I've not had any corruption issues (unless
> this is one).

Bob,
You said this:

> My backups indicate that the change occurred in the last 2 days, and
> occurred in my master copy of the front end as well as the distributed
> mde,

This means that these changes occurred *without* distributing a new mde ???
Sounds like magic to me, unless there is code inside the app that makes the
changes.

Arno R.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.