Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Prevent database created in SQL Server to be displayed in Ms Access

Discussion Prevent database created in SQL Server to be displayed in Ms Access

  • Thursday, February 21, 2013 6:12 AM
     
     
    Sign In to Vote
    0
    Hi Everyone !! I have created a database in Visual studio 2005 and I could be able to open it from my MS Access ..I need this to be prevented i.e i dont want my database to be opened in Ms Access...How could i make it? Please help me....
     

All Replies

  • Thursday, February 21, 2013 4:47 PM
     
     
    Sign In to Vote
    0
    I think you can open a sql server db in access is through ODBC connection  in admininstrative tasks. and of course user should have permission to access the db.
    Try restricting the user to be able to that or not give permissions to connect to the sql server. this way even if the user tries to make ODBC connection, it cannot go through because he cannot connect to database engine

    Hope it Helps!!

     
  • Thursday, February 21, 2013 8:40 PM
     
     
    Sign In to Vote
    0
    More info on SQL Server at http://social.msdn.microsoft.com/Forums/en-AU/sqlsecurity/thread/83802d78-7b01-4b32-84c9-57f7312f1db2

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty