[AccessD] Security Problem w/existing program

John,

<<The program is working fine actually, but the security has disappeared.>>

  Please define "disappeared".  What is or is not happening?

<< I am
now wondering if this is using some add-in that supercedes standard
security procedures.>>

  Access databases can have any extention and still execute (except for
LDB).  It is possible that the developer has implemented their own security
setup within the app and Access security is not being used.

  I would also ask; Has anything changed recently?  Hardware, software, OS,
setup, etc.

Jim.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Clark
Sent: Monday, August 08, 2005 9:19 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Security Problem w/existing program


Somebody at work came to me w/a problem today. Their program, which runs
on a Citrix box, is written in AXP, so they figured I could help them. I
am feeling a little dumb though because I'm not getting anywhere w/it.

The program is working fine actually, but the security has disappeared.
Now, I don't have much experience with Access security to begin with,
but I have been able to muddle my through it, in the past. However,
everything I've dealt with in the past seemed to include an MDW file,
but no such animal exists in this environment (did this go away with
XP?). I looked at a backup directory they have and it isn't there
either, which leads me to believe it is not just missing.

Instead however, there are a bunch of files I have never worked with
(i.e. .MDO, .MOD, .ODB, .MDA, .MOA). I found nothing, in a search, for
.MDO files, but I found out that .MDA files are "Access Add-ins." I am
now wondering if this is using some add-in that supercedes standard
security procedures. When working though, I believe it acts the same
way...they still go into DB security and manipulate workgroups and
users, and their rights.

Does anyone have any ideas of how I can troubleshoot this? I realize I
may not be giving enough info, but I really don't know what else to add,
at this point, so just ask if you need it. I am headed back into it now,
but I'll check back in a bit to see what y'all might have for me.

Thank you!

John W Clark
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com