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 / SQL Server / ADP / August 2005

Tip: Looking for answers? Try searching our database.

Security MDB vs ADP (SQLServer)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dimitrios Tanis - 06 Aug 2005 10:30 GMT
It is a fact that an mdb file security is more than easy to get passed to, I
couldn't help noticing that SQL server users promote the security features
of SQLServer. Thus I am cought between access mdb and access adp using SQL
server 2000 DE. What are the security advantages of using the second, and
what does it differ from a full SQL Server 2000???

Thanx in advance.
Sylvain Lafontaine - 06 Aug 2005 22:27 GMT
There is no real difference between the Desktop Edition and the Standard or
the Enterprise Editions when it comes to security; however there are when
you look at the location of these databases: setting a SQL-Server on a
desktop machine with all the trojans, viruses and hackers that may affect or
attack a personal machine with a full connection to the local LAN and the
WAN is much less secure than setting it on a isolated server located behind
its own firewall and with only the minimal network access and applications
running on it.

Machines that are used for everything in the office are also known for their
bad tendencies to collect every virus and trojan that may come around and to
be a prime target for hackers.

A local user will also have a much easier way to hack his way to the data
files of SQL-Server than he will have for a machine which is physically
locked away and doesn't provide any direct access to its desktop and file
systems and that will show to the exterior (including the local LAN) only
the TCP/IP service port of SQL-Server.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> It is a fact that an mdb file security is more than easy to get passed to,
> I couldn't help noticing that SQL server users promote the security
[quoted text clipped - 3 lines]
>
> Thanx in advance.
 
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.