Acessing SQL Server tables with MS Access

• cross

  SSCommitted

  Points: 1735

  More actions

  July 22, 2003 at 8:02 am

  #159549

  I've never tried it but I know with an account and password a person can get to SQL Server tables with Microsoft Access. Is there any other way to prevent this besides the account/password authentication?

  Edited by - cross on 07/22/2003 08:04:09 AM

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  July 22, 2003 at 8:24 am

  #466411

  Hi cross,

  quote:

  ---

  I've never tried it but I know with an account and password a person can get to SQL Server tables with Microsoft Access. Is there any other way to prevent this besides the account/password authentication?

  ---

  maybe this thread will help you

  http://sqlservercentral.com/forum/link.asp?TOPIC_ID=13845

  I would prefer to install M$ Access only on machines with users who hopefully know what they are doing

  Cheers,

  Frank

  Edited by - a5xo3z1 on 07/22/2003 08:25:41 AM

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]