April 11, 2000 01:28 PM

Securing SQL Server Through Access

Rating: (0)
SQL Server Magazine
InstantDoc ID #8552
Learn SQL Server security basics for Access 2000 projects
As Microsoft Access developers who are used to the Jet engine begin to create SQL Server and Microsoft Data Engine (MSDE) solutions with Access 2000, they'll need to learn a new security model. For example, unlike security for Jet database files, SQL Server security distinguishes between login accounts and user accounts. Understanding the basics of SQL Server security for tables provides a foundation for understa...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

"You can create a new login that maps to a user account by choosing Tools, Security, Database Security from an Access project's Database window menu."
Depends which version we are talking about Access XP / 2003 do not have this or any similar option!
This is aricle is of little use to anyone running these versions :(

Anonymous User 4/4/2005 4:28:52 AM


Missing in your article.

My question : I want a user to be given update , delete permission only through an application , but throught a query anayzer. How to do it.

satish4/25/2004 4:27:01 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS