Access Data Base Security
I want to Secure my Data base which is distributed with my VB application
. I am using ADODB connection to connect with my databae, but i am unable
to open it .This password is for only data base security .My code is as follows.
Private Sub Form _Load()
set myConn = New adodb.Connection
strconnect = App.Path & "\wisdom\dbc.mdb"
myConn.open strConnect, "Admin" ,"password",
Private sub Listbookonly-DBlclick()
strAnswer = Listbookonly .Text
Set myRS = New adodb.Recordset
StrSQL = "Select [Title] , [Name of Book], [Page number (E)] from Hikmat
where [Name of Book] like "&"'%" & StrAnswer &"%"'
myRs.open strSQL ,myconn,adOpenKeyset,adLockOptimistic,adcmdText
Where Hikmat is the name of my table in database dbc.mdb
Please suggest is any syntax error or some other code is needed
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL