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 / Security / September 2004

Tip: Looking for answers? Try searching our database.

Backend Security

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 20 Sep 2004 20:30 GMT
I have an Access 2000 db that is secured.  I just splitted
it.  The Front end is still secured, but that back end is
not.  If someone were to go to the the backend folder on
the network, they could delete data.  How do I secure the
backend with the same Secured.mdw that is used on the
front end?
'69 Camaro - 20 Sep 2004 21:08 GMT
Hi, Steve.

> I have an Access 2000 db that is secured.  I just splitted
> it.  The Front end is still secured, but that back end is
> not.

That's the problem with using the Database Splitter Wizard.  It completely
ignores security.

To split it properly, one needs to make an extra copy of the unsplit
database and store that copy where the back end should be.  Then, one should
delete all objects in this back end copy, except the tables and
relationships.  Next, in the original database, the front end, the tables
should be deleted and new links created to the tables in the back end.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

> I have an Access 2000 db that is secured.  I just splitted
> it.  The Front end is still secured, but that back end is
> not.  If someone were to go to the the backend folder on
> the network, they could delete data.  How do I secure the
> backend with the same Secured.mdw that is used on the
> front end?
Steve - 21 Sep 2004 15:17 GMT
Excellent.  Thanks.
>-----Original Message-----
>Hi, Steve.
[quoted text clipped - 30 lines]
>
>.
'69 Camaro - 22 Sep 2004 04:14 GMT
You're welcome!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

> Excellent.  Thanks.
> >-----Original Message-----
[quoted text clipped - 47 lines]
> >
> >.
 
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.