Visual Basic

FirstPrevNext

VB.NET accessing MS Access with password problem... [modified] lordkaile29-Jul-06 18:27 lordkaile 29-Jul-06 18:27  Greetings everyone! i'm a junior programmer of VBNET.. I don't have an SQL Server and im still not into hard coding SQL... so i'm using MS access as my database.. The problem is, i like to set a password on my database..let's say 'depedsys.mdb' is my database file.. but if i set a password in it.. can't access it on VBNET.. Im using the Microsoft JET Oledb 4.0 Provider.. Anyone can help me out with this? Thanks in advance.. -Kai Kai Studios -- modified at 0:28 Sunday 30th July, 2006 Kai Studios Re: VB.NET accessing MS Access with password problem... Guffa29-Jul-06 23:21 Guffa 29-Jul-06 23:21  Specify the user name "admin" and the password in the connection string. Example: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\somepath\mydb.mdb;User Id=admin;Password=whatever" --- b { font-weight: normal; } Re: VB.NET accessing MS Access with password problem... lordkaile31-Jul-06 15:58 lordkaile 31-Jul-06 15:58  Thanks for the answer.. but the user id and password pertains to a SQL server... i think.. i've tried that b4.. and the password isn't the password of the access database.. -Kai Re: VB.NET accessing MS Access with password problem... Guffa1-Aug-06 6:19 Guffa 1-Aug-06 6:19  Why do you think so? That connection string is not for SQL Server, it's for Access. --- b { font-weight: normal; } Re: VB.NET accessing MS Access with password problem... lordkaile3-Aug-06 23:53 lordkaile 3-Aug-06 23:53  i have tried it b4 and it's really not for access, in the first place setting password to an access database does not require username..and if u use the password with the username, it will juz prompt an invalid password.. it's alright, thanks anyway : ) Re: VB.NET accessing MS Access with password problem... Stephen McGuire30-Jul-06 4:28 Stephen McGuire 30-Jul-06 4:28  Try this for your connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\path\myDB.mdb;Jet OLEDB:Database Password=myPassword" If the database is located in the application folder, you could use: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\myDB.mdb;Jet OLEDB:Database Password=myPassword" Steve Re: VB.NET accessing MS Access with password problem... lordkaile31-Jul-06 15:51 lordkaile 31-Jul-06 15:51  I always put my database inside the bin or in a folder inside the bin.. i'll try your connection string, thanks! -Kai Re: VB.NET accessing MS Access with password problem... Stephen McGuire1-Aug-06 2:50 Stephen McGuire 1-Aug-06 2:50  If your DB is in the bin folder you could use: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\bin\myDB.mdb;Jet OLEDB:Database Password=myPassword" This will be ok during development but when you deploy your app this connection string will not work unless you install your DB to a bin folder under your app folder. Most likely you will need to change it at the deployment stage to: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\myDB.mdb;Jet OLEDB:Database Password=myPassword" ...if the DB is installed to the app folder. Otherwise you will have to change the 'Data Source=' to point to the actual folder that contains your back-end DB. Steve Re: VB.NET accessing MS Access with password problem... lordkaile3-Aug-06 23:56 lordkaile 3-Aug-06 23:56  Steve! i've tried your connection string and it worked! Thanks a lot man! now i dont have to worry about my database being vulnerable..! Thanks for the help! -Kai Re: VB.NET accessing MS Access with password problem... Stephen McGuire4-Aug-06 1:07 Stephen McGuire 4-Aug-06 1:07  Great! Pleased to help. Be aware that Access databases are not that secure. A utility available on the Internet for about $45.00 can break the pasword protection. Access DB's are great for doing a lot of things but if security is a real issue, you would be better to choose SQL Server or another more secure database model. Steve Binding a DateTime Picker or a text box to a date field TheFoZ29-Jul-06 8:48 TheFoZ 29-Jul-06 8:48  Hello I am trying to bind a Date Time Picker to a "Date/Time" field in an Access database. 1st of all I tried to bind the DateTimePicker with the "Value" property and that didn't work so I tried to bind the date to a text box and that didn't work. The error I keep getting is:- System.ArgumentException Cannot Bind to property or column TheDate on DataSource. Any Ideas Many Thanks The FOZ media player control Vineet Rajan29-Jul-06 6:40 Vineet Rajan 29-Jul-06 6:40  hi all this is what i plan to impliment. create a media server with some videos. develop an application to select the file and view it. i would be implimenting it on my college network. i do not plan to use media streaming. i would need help on the following: 1. how do i get the media player up and running? does it have the functions to connect to the database and fetch the file? 2. whats the best way to impliment the database. should i keep an index in a databse like SQL or access? regards Vineet Re: media player control Christian Graus30-Jul-06 12:43 Christian Graus 30-Jul-06 12:43  media files are big, so I wouldn't use a database to store the files, just store paths to the files on the file system. Then, your media player can connect to the actual files over the networ, all you need to do is tell it where to look. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog Internet transfer control error. Aaron12829-Jul-06 5:38 Aaron128 29-Jul-06 5:38  Hello, I'm using VB.NET 2005, I am trying to use the Internet Transfer Control to load a web page source into a rich text box and then index all the words into a SQL database, but when I tell the Internet Transfer Control to open a URL it gives the following error Exception from HRESULT: 0x800A8BA8 The URL comes from a text box, when I press a button. I would be very grateful for any help Thanks Aaron VB.NET - Urgent - My webserver sends html fine but not binary!? steve_ino29-Jul-06 5:06 steve_ino 29-Jul-06 5:06  I have a multi-threaded webserver core written in VB.NET. I have gotten it to parse headers, send HTML Documents, etc... But whenever i send images they show as an X or corrupted...i was thinking i wasnt sending or reading in the right mode...but i read in binary to a byte array and i send as a byte array so im very confused... You can view my current source code here: http://prdownloads.sourceforge.net/caedo/CaedoHTTPd.rar?download it would greatly appreciate help, so i can finish porting my webserver to .net and further advance the possibilities. If you can help, please reply asap! Graphics Object problem microuser_200029-Jul-06 0:23 microuser_2000 29-Jul-06 0:23  hellow to all i am drawing a graphics object on a picture box , when i click a button , i see the shapes , but after i move to other form the shapes fade away , is there any way to solve this problem ? , i think i am missing a line of command , that save the image , thx for anyhelp .. Re: Graphics Object problem Guffa29-Jul-06 8:17 Guffa 29-Jul-06 8:17  You can't just draw things on the screen, and expect them to get magically attached to the control that happens to be at the location where you draw. You have to catch the draw event of the control and use that to draw the graphics. --- b { font-weight: normal; } Re: Graphics Object problem microuser_200030-Jul-06 20:18 microuser_2000 30-Jul-06 20:18  and how i can do this ? Re: Graphics Object problem Guffa1-Aug-06 5:57 Guffa 1-Aug-06 5:57  Inherit from the control and override the OnPaint method, or make an event delegate and add to the Paint event. --- b { font-weight: normal; } Re: Graphics Object problem microuser_20001-Aug-06 12:53 microuser_2000 1-Aug-06 12:53  can u provide me with link how to apply this method ? VB.net --> JavaScript event t3j029-Jul-06 0:04 t3j0 29-Jul-06 0:04  I build a web based aplication useing shdocview (axwebBrowserobj1 -- internet explorer control). using mshtml class (mshtml.tlb) i can manipulate my html page,.. but then i have difficulties about how to make VB.NET cature HTML event (like some button (input type button) onclick event ,.. to execute my vb.net procedure. any body have idea,... plz help,.. DBASE 5 Database access and searching kd8con28-Jul-06 14:45 kd8con 28-Jul-06 14:45  I'm working on a project that needs to search a database - one particular field of the database actually and find the record that contains the searched text in that field. If not found display a message box that states that then go load another form to add the record that isn't there. I don't want to use classes if possible. Is this possible with VB6? Steve Smith Re: DBASE 5 Database access and searching kd8con28-Jul-06 14:47 kd8con 28-Jul-06 14:47  oh yea, this database table has an index as well - I never did figure out how to utilize that index. I'm familiar with clipper but haven't done anything with a database in vb6 yet. Thanks again Steve non rectangular control Dobromir Dimitrov28-Jul-06 11:26 Dobromir Dimitrov 28-Jul-06 11:26  Hi there. I have the following problem: I need to make a control that has an irregular shape. So far so good - I have no problem drawing it using something like this: Private Sub TabPage4_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles TabPage4.Paint Dim myPointArray As Point() = {New Point(50, 50), New Point(100, 120), New Point(140, 100)} Dim MyGraphics As Graphics = e.Graphics Dim MyPen As New Pen(Color.Azure, 2) Dim mySolidBrush As New SolidBrush(Color.Aqua) myGraphics.DrawClosedCurve(myPen, myPointArray) MyGraphics.FillClosedCurve(mySolidBrush, myPointArray) End Sub So now I have drawn part of the control. The problem comes when I try to raise an event regarding the irregular shape I've drawn, not the ractangle containing it. Can anyone help me with an idea, or maybe a hole new different approach to make such a control? Inventory stevelizardi28-Jul-06 10:26 stevelizardi 28-Jul-06 10:26  I need to build a program that does inventory. Then a form to subtract that inventory from what is on hand noting a account number or a name. can anyone help me. If it isnt one thing it is something else. I am new to VB.net, so i am still learning. thanks! steve

Last Visit: 31-Dec-99 18:00     Last Update: 18-Jun-24 9:42 Refresh ᐊ Prev1...3247324832493250325132523253325432553256 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.