Re: Linking table without duplicating PK



On Dec 20, 1:17 am, "accessuser via AccessMonster.com" <u28669@uwe>
wrote:
the problem is HR does not want the employees to even go into
this program. I understand by spliting it, limits their access, set
passwords, but all those can still be hacked if those people know how to use
Access. HR does not want to take those chances. I don't want to promise them
that it is totally safe when it is not......So I need to look for alternative.

It's a matter of trust, then.

Do HR trust network permissions i.e. can the two applications reside on
the same network? If so, you may be able to convince them that two
applications can share safely share the same database. However, IMO the
security in Access/Jet is inadequate for the required task. Consider
something more 'industrial strength.' e.g. security in SQL Server is
excellent, even in the free versions (MSDE 2000, SQL Server 2005
Express).

Data integrity is also an important and will be more easily achieved if
the data resides in the same database.

Jamie.

--

.

Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... SQL Server 2000 Out-of-the-Box database security solution. ... database protection and privacy software is an industry-proven ...
    (microsoft.public.sqlserver.security)
  • Re: SQL or Access DB
    ... i am aware of the security modell of SQL server (we do use SQL server ... an end user,,, there is not reall alternative as a worgroup Access database ... MSDE and SQL express are all free ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... A company is vulnerable when its security ... > database encryption solution with protected key-management software ... > tested by the SQL Server Test Lab. ...
    (microsoft.public.sqlserver.security)
  • Re: Trusted connections??
    ... implement role or user based security at the SQL Server. ... If the ASP.Net app controls what the user can request of the database then I ... I implement user authentication at the application and the application ...
    (microsoft.public.dotnet.framework.aspnet)
Loading