Access 2000 Windows 2000 folder permissions

[prodeji]

Hi

Don't know if I'm posting this in the (most) relevant group but not
sure where to post it and not getting anywhere digging on my own -
probably not using the correct keywords.

Anyway, my dilemma is this:
I'm building an application that needs to link to an access database in
a folder on a Windows 2000 network.

The users of the application do not have access to the folder the
database is in - yep, you guessed it, it's Human Resources! - and so
the application can't access the information it needs to.

The database the application needs is, of course, confidential (the
whole folder it's in is 'confidential'; it's HR after all) <rolling
eyes> and the powers-that-be will not sign off on moving it to a folder
with more universal access.

I've explored replication but:
a) I haven't had time to get it down enough to be able to automate it
b) It'll result in the same confidentiality problem

Is there any way (yeah I'm aware this may be a dumb question) the
application can circumvent the permission restrictions and access the
tables it needs in the Access database?

My reasoning is that the users won't have 'access' to the restricted
folder; they'll never even see the contents or have any way to retrieve
anything other than what the appication is built to retrieve, which is
non-confidential information, so there might be a way to do it.

I'm also aware the solution, if there is one, may be found in a Windows
2000 group rather than an Access group but thought I'd start here.

Any guidance is appreciated.

Thanks,

 

[prodeji]

Hi Granny,

Glad to see i was in the ballpark about there being a way to get around
the 'security' whether it's ethical or not

Time and other constraints won't allow me to rework the restricted
database as suggested, so I guess I'll have to go an alternate (less
secure) route.

Thanks for the info, though, much appreciated.

prodeji