Security MDB vs ADP (SQLServer)

  • Thread starter Dimitrios Tanis
  • Start date

Dimitrios Tanis

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

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adp vs mdb 42
.mdb or .adp which is best to use with SQL 2K 10
Future of ADP - new article 12
ADP vs. MDB? 16
ADP searches vs. MDB 6
Secure an adp file? 3
link a text file using a .adp application 2
ADP vs. MDB: Speed 61