MS Access Project Security

[dougloj]

Hi.

This might seem to be some silly questions, but ...

I have an Access 2003 project (.adp) running under Windows 2000 or
Windows XP Professional that connects to a secured SQL Server database
at a major hosting company. In order for the project to access the
database, it must provide a user name and password in the
ConnectionString. I connect to the database via a standard DSL
connection.

How secure is my connection between the Access project and the
database?

In the Access Data Link Properties under File->Connection, I tried to
set Use Encryption for Data to True, but it failed because encryption
is not supported on the SQL Server.Is there anything I should do to
help ensure the connection?

Should I worry about it, ot does the SQL Server and/or Access provide a
sufficient level of security?

All thoughts are appreciated. Thanks for the bandwidth!

Doug

 

[Arvin Meyer [MVP]]

Remember, before you can even open Access or SQL-Server, you need to
authenticate on a Windows network. Enforcement of strong pass-phrases and
judicious security goes a long way to protecting access to the database. If
you need WAN coverage, you need a hardware firewall at both ends to encrypt
the transmissions.

That said, anyone who is really determined will probably find a way to get
the data. I believe in strong intrusion detection by logging traffic access.
If you catch a thief, deal with him (or her) harshly.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access