|
hai friends
i have a problem in access Ms-access database table..
for the database , i set a password...
and i written the following code to access it ....
Try
Dim con As New OleDbConnection("Provider=Microsoft.JET.OleDb.4.0;User Id=administrator;Password=xyz;Data Source=D:/DataBase/Master.mdb")
Dim da As New OleDbDataAdapter("select * from login", con)
Dim ds As New DataSet
da.Fill(ds, "login")
DataGridView1.DataSource = ds
Catch ex As Exception
MessageBox.Show(ex.Message, "database")
End Try
but it is giving the error like ...
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
then i closed all the files , even i restarted the system ....
but it is giving the error...
wt would be the problem ....
either in setting the password for the database
or in vb.net ( in the above code )
plz help me....
thanks in advance
vijay
|
|
|
|
|
try this code
I think this will work
' your connection string will be
Provider=Microsoft.Jet.OLEDB.4.0;Data Source = D:/DataBase/Master.mdb ; Persist Security Info=True ;Jet OLEDB:Database Password=xyz" 
|
|
|
|
|
Reverse the slashes in your connection string. Forward slashes are for command line parameters. Backslashes (\) are for file path names.
Your Access database has either has a database password or workgroup security setup on it. You can find the connection string format for this at http://www.connectionstrings.com[^]. You're using OLEDB (.NET). Do not use the ODBC versions!
If you have workgroup security, you have to specify the databases .MDW file in the string along with the database filename.
|
|
|
|
|
hai dave
thank u so much ....
its working ...
i used the connection strings site which u given...
thank u so much ....
really i mwaiting for it since from 1 week ....
once again thank u so muchhh ...
oke bye
vijay
|
|
|
|
|
hai friends
i given security with code
i.e on execution of the project , it will ask "enter Project Access Key "
then the user enters the key and the execution continues.
but the problem is ..
if the user closes the application/shut down the computer , it is again asking the Key...
i want to ask the only once when the project is run for the first time only....
plz help me ....
thanks in advance
vijay
devulapally_vijay@yahoo.co.in
|
|
|
|
|
You can store the key in the registry, or in a config file, or in any sort of file you like, really. I tend to come up with my own file format to store stuff like that, but what you do is up to you. Then your code needs to check if the file exists and the key is valid, obviously.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I want to show my print preview to user in landscape but now it depends on user printer setting .
please help me how to do that .
thanks .
en.Mahdi
|
|
|
|
|
Hello all,
I am trying to write a VB program that will listen to signals coming from com ports, the kind of program that listens to signals coming from a bar code scanner, etc. (the scanner reads a bar code, sends the info to a comport, then the signal is picked up by a listening software). I've been looking online for materials on the subject, but did not come across any written in VB. Most are written in C and Java, which leads me to think that perhaps you can't do it with VB. If you know where I can find info for what I am looking for, please inform me. Thank you in advance for your time.
modified on Friday, April 11, 2008 11:48 PM
|
|
|
|
|
Which version of VB?? VBA, VB6, VB.NET 2002 (.NET 1.0), VB.NET 2003 (.NET 1.1), VB.NET 2005 (.NET 2.0 and 3.0), or VB.NET 2008 (.NET 2.0, 3.0, and 3.5)??
|
|
|
|
|
I am currently using VB2005 .net 2.0 and if you know of a website that talks about what I am trying to do, please inform me. Thanks again for your time.
|
|
|
|
|
|
You'd use the Serial Port class[^] included in the System.Io Namespace
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
Hello everyone,
Thank you for your time, you've been helpful. I am checking out all of your suggestions.
|
|
|
|
|
hey all, ok i have this really small program that needs one more thing to get it completed and i am extremly new to visual basic and i just can't figure this out.
Ok, so this is a program that when u debug it, you put in you first and last name and then click calculate, then an inputbox comes up asking: "What grade do you teach?" you can put any grade in, so i put "6" in (without the quotes) and then when i click ok another box comes up and is susposed to say, "John Smith teaches grade 6" but when i click the ok button it only displays "John smith teaches grade" and doesn't display the number 6, that's all i am tryign to display. Does any one no how to get that number 6, or any number really to be displayed? If you could check this out that'd be great! Here is the code, the interface is 2 text boxes, 1 asking for your first name and the other asking for your last name, and a button saying "calculate"
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Employee As New Person
Dim strgrade As Integer
Dim DOB As Date
Employee.FirstName = TextBox1.Text
Employee.LastName = TextBox2.Text
strgrade = InputBox("What Grade Do you Teach?", "Grade Ask")
MessageBox.Show(Employee.FirstName & " " & Employee.LastName _
& " teaches grade " & Employee.Age(DOB) & "")
End Sub
End Class
Public Class Person
Private Name1 As String
Private Name2 As String
Public Property FirstName() As String
Get
Return Name1
End Get
Set(ByVal value As String)
Name1 = value
End Set
End Property
Public Property LastName() As String
Get
Return Name2
End Get
Set(ByVal value As String)
Name2 = value
End Set
End Property
Public Function Age(ByVal Birthday As Date) As Integer
Return Int(Now.Subtract(Birthday).Days / 365.25)
End Function
End Class
Public Class Teacher
Inherits Person
End Class
/J-Man\
|
|
|
|
|
jesseax wrote: strgrade = InputBox("What Grade Do you Teach?", "Grade Ask")
MessageBox.Show(Employee.FirstName & " " & Employee.LastName _
& " teaches grade " & Employee.Age(DOB) & "")
Did you try stepping through the code?? You get a string value from an InputBox and you store it in strgrade. Then what does your code do with it??
|
|
|
|
|
 ok i "stepped into" it and nothing happens once it gets into the string, it displays "John Smith teaches grade 2007" because of the DOB...
I no this program seems weird, but my prof. gave this to me as a birthday date program, originaly you were suspossed to put in ur first and last name and then you picked a date from this calendar and then once u clicked ok it would display in a messageBox saying "John Smith is 6 years old." But just for fun he gave this to me and told me to try and ask around to see if i could get it working. because he has the working one and won't show it to me until i have it working.
/J-Man\
|
|
|
|
|
OK, so were are you filling in the DOB property of your class?? How are you getting the OB from the user??
|
|
|
|
|
|
I don't need to look at it. The questions I'm asking are the ones YOU should be asking and doing the research to find out what the answers are or what you need to do to answer those questions.
|
|
|
|
|
o ok sorry, isn't this fourm here to help and direct me in the right direction... can anyone else anser to this problem i'm having, i don't see why just you have to respond, this is the best fourm i'm told to, all other VB forums suck. does anyone else know what else i'd need to?
/J-Man\
|
|
|
|
|
Let's see, you've been given an assignment, one where you have to solve a problem. Then you come here and just want the answer to the problem handed to you. What would you learn in the process?? Would you pass the assignment?? Maybe. But, will you pass the next one??
You already have everything you need to solve the problem. You've been given all kinds of hints on where to look and what you might want to search for and do research on. BTW: The #1 skill you MUST have as a developer is the ability to do research on problems and possible solutions. It's not actually writing code...
|
|
|
|
|
ok well i am still going to mess around with this program. I am not going to be a developer because theres a ridiculous amount of crap you have to learn in order to be able to code something. there is so much crap that i not needed in visual basic. This course is just a requirement that is part part of my degree.
/J-Man\
|
|
|
|
|
The research skills apply to problem solving. That's the whole point behind the exercise. Your problem can be solved in a single line of code. Noone here is going to write it for you because you won't learn anything if we did.
|
|
|
|
|
wow do i feel like a douche... I read over your replys a few times, i really thought about it and did research for an hour today and some how i got the program to work. It displays the corret message and everything, and you were totaly right and i didn't even see it, "The #1 skill you MUST have as a developer is the ability to do research on problems and possible solutions." i just wanna thank you for giving me that tip, i gave it some though last night and i made it happen today!
/J-Man\
|
|
|
|
|
 That little skill applies to everything Engineering, software or otherwise.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
