473,320 Members | 1,909 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Permissions for one form changed

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.
--
Bob Darlington
Brisbane
Jun 14 '06 #1
4 1326
Did you have corruption issues ? and because of that
did you do something as SaveAsTxt <> SaveFromTxt ?

Arno R

"Bob Darlington" <bo*@dpcmanAX.com.au> schreef in bericht news:44***********************@news.optusnet.com.a u...
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.


--
Bob Darlington
Brisbane

Jun 14 '06 #2
Arno,
Thanks for your reply, but no, I've not had any corruption issues (unless
this is one).

--
Bob Darlington
Brisbane
"Arno R" <ar***********@tiscali.nl> wrote in message
news:44**********************@text.nova.planet.nl. ..
Did you have corruption issues ? and because of that
did you do something as SaveAsTxt <> SaveFromTxt ?

Arno R

"Bob Darlington" <bo*@dpcmanAX.com.au> schreef in bericht
news:44***********************@news.optusnet.com.a u...
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.
--
Bob Darlington
Brisbane

Jun 15 '06 #3

"Bob Darlington" <bo*@dpcmanAX.com.au> schreef in bericht news:44***********************@news.optusnet.com.a u...
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.
Jun 15 '06 #4
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.

--
Bob Darlington
Brisbane
"Arno R" <ar***********@tiscali.nl> wrote in message
news:44**********************@text.nova.planet.nl. ..

"Bob Darlington" <bo*@dpcmanAX.com.au> schreef in bericht
news:44***********************@news.optusnet.com.a u...
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.

Jun 16 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Brad H McCollum | last post by:
I'm writing an application using VB 6.0 as the front-end GUI, and the MSDE version of SQL Server as the back-end (it's a program for a really small # of users --- less then 3-4). I'm trying to...
1
by: Brad H McCollum | last post by:
I've looked through many suggestions and partial examples all over this newsgroup and still am not coming up with anything that does specifically what I'm wanting to accomplish. I'm writing a VB...
0
by: Laertes | last post by:
Hi, I'm trying to use the example in the Security FAQ to change a user's permissions for a form by logging on a "security-enhanced" workspace. The thing is that I want to do that AFTER the...
2
by: Jozef | last post by:
Hello, Is there a way to change table permissions in VB Code? I can't seem to find much that's concise in the help file. Here's the situation; I have a table in the "data" portion of a split...
0
by: VP | last post by:
Hi there, well i am stuck on a problem with regards to obtaining security permissions on folders. At the moment I have created a simple treeview example which shows all sub-directories in a tree...
0
by: Isabelle | last post by:
Hi I have posted this in the microsoft.public.frontpage newsgroups. Since it involves both Frontpage ext. 2002 on a windows 2000 Advanced's web server, and ASP.Net (framework 1.0), I decided to...
6
by: alex | last post by:
Hi, this always works: private ConsoleToTextbox myConsole; Console.SetOut(myConsole); But now (a few weeks later i started this project again) i get a non handeld security exception from...
1
by: beary | last post by:
Hello everyone, I'm not sure if this is the correct forum for this, and apologies for the length of this question, but I'm desperate for some good advice... I'm in way over my head with file...
2
by: beary | last post by:
Hello everyone, I posted this in unix/linux but it received no replies, so I assume it was the wrong forum. I'm trying here. I'm in way over my head with file permissions. The directory and...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.