ADO Beginners Tutorial

[si_the_geek]

The tutorial shows how to connect to an Access database, all you should need to change is the file name/location.

If you need further help, see the Connection Strings link in my signature.

[ididntdoit]

I'm trying to open a database w/ a password, I can open it fine when there's no password, but what code do I use to add the password?

this is the mods I made to the code so far, but is says that "Could not find installable ISAM"

Set cn = New ADODB.Connection 'we've declared it as a ADODB connection lets set it.
    cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source= c:\DB1.mdb;Jet OLEDB;Database Password=mypassword" 'this is the connection string explained in the notes section.
    cn.Open

Thanx

p.s. code snippets help me, I'm a real noob, and a visual learner


also, is there a way to change the password on the .mbd file inside the program? The problem I actually have is that the messaging program I'm making uses a text file to store lots of user settings, the problem is is that an idiot in my class tries to screw it up constantly, so when I boot him off of it, he has already made a copy of the program storring the info, so he just replaces it back, and he's back on. I want a way to change the password without having to re-compile the program to change the password, to render his old copy uselesss