BE in secured file on server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CarlaInJax - 01 Apr 2008 12:21 GMT

I have a split database with the BE on the server. Someone went into my file
on the server and deleted over 2,000 records from my table. In an effort to
keep this from happening again, my IT people set it up so that only I could
access my file on the server. Now when users click on the FE that is loaded
on their machine, they are denied access to my file. Is there a way around
this so that users can access the data they need, but leaving the BE in my
secured file?
Thanks.

Reply to this Message

Rick Brandt - 01 Apr 2008 12:44 GMT

> I have a split database with the BE on the server. Someone went into
> my file on the server and deleted over 2,000 records from my table.
[quoted text clipped - 4 lines]
> access the data they need, but leaving the BE in my secured file?
> Thanks.

Not really, That is the nature of a file-based database.

You can implement Access User Level Security to limit what people can do
based on permissions, groups, etc, but that is an advanced topic, and even
that can be defeated by someone determined enough to obtain the utilities to
do so.

For better control than that you would need to use a server back end like
SQL Server.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

CarlaInJax - 01 Apr 2008 12:57 GMT

OK, so rather than have my IT guys unsecure my file (I have other stuff I'd
like to keep secure), I copied my BE to the served in an unsecured file and
and linked my FE to the new BE. However, it is now telling me that the
command could not be executed.
?Any ideas?

> > I have a split database with the BE on the server. Someone went into
> > my file on the server and deleted over 2,000 records from my table.
[quoted text clipped - 14 lines]
> For better control than that you would need to use a server back end like
> SQL Server.

Reply to this Message

NetworkTrade - 05 Apr 2008 21:26 GMT

am a little confused;

.mdb User Level Security can prevent a normal user from accessing the
backend directly.

It can also (along with the front end design by you) prevent them from
deleting records via the FrontEnd. Don't over look this; depending on your
design they may have deleted the records without even directly goint to the
backend file....

It is true that a confirmed cracker can pretty easily find ways around this
- - but most casual work related malicious/accidental will be stopped....

Signature

NTC

> OK, so rather than have my IT guys unsecure my file (I have other stuff I'd
> like to keep secure), I copied my BE to the served in an unsecured file and
[quoted text clipped - 20 lines]
> > For better control than that you would need to use a server back end like
> > SQL Server.

Reply to this Message