Thursday, February 21, 2013 6:12 AMHi 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....
Thursday, February 21, 2013 4:47 PMI 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 PMMore 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