Security

T

Tom Collins

I'm working on an Access database that I have to fix. They were using Access
security through an MDW. I have removed all security and converted the
backend to SQL Server. I still have a little debugging to do, but I wanted
to go ahead and throw this out now.

What kind of security would most of you recommend. Restore the MDW or
program my own? I'm not even sure if the MDW will protect the linked tables.
I can't use their network ID as sometimes an intern is using a computer
logged in as someone else. Are their any good templates or samples out there
that someone can point me to?

Thanks

Tom Collins
 
A

Arvin Meyer

If you are continuing to use the Access MDB front-end, you are pretty much
locked in to using the user-level Access security to protect objects unless
you build an MDE. That means the MDW.

OTOH you can (and should) use SQL-Server or integrated NT security on the
data. As far as interns logging in as someone else, stop it now! That is a
serious breach of the most basic of security rules. Almost better to have no
security at all than that. Every individual has his or her own account.
Always, without exception.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
T

Tom Wickerath

Hi Tom,

You need to use SQL Server's features to protect your data. This includes
not having "sa" as the default user with a blank password. Your question will
likely get a better answer if you post in a SQL Server newsgroup. I suspect
that you will want to use the Windows authentication credentials (logged on
username) and compare this against a list of users that you maintain in a
table in the back-end database. This table would include a field that defines
the data each user is allowed to see.

Tom
______________________________________

:

I'm working on an Access database that I have to fix. They were using Access
security through an MDW. I have removed all security and converted the
backend to SQL Server. I still have a little debugging to do, but I wanted
to go ahead and throw this out now.

What kind of security would most of you recommend. Restore the MDW or
program my own? I'm not even sure if the MDW will protect the linked tables.
I can't use their network ID as sometimes an intern is using a computer
logged in as someone else. Are their any good templates or samples out there
that someone can point me to?

Thanks

Tom Collins
 
Top