MSACCESS Database with Passwords

[Codehammer]

Hi,

I Have MSACCESS Database with Password Setup. When Opening the Database in Access it Asks for it. When in VB.net 2003, I Use the oledbDataconnection. This Asks for the Password and username, I Tried All Combinations, Passowrd Only, Admin, Administrator as Username, Blank Username, Password Only, Etc.
In MSACCESS Do I Need to Set up Workgroups or something under Security. MSACCESS - ver.2003

[CyberHawke]

This should get you into the db

Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password='YourPassword';Data Source=C:\Program Files\MyProgram\MyDatabase.mdb;")

You will have to ignore the it's a result of the website not knowing how to parse out actual text from an attempt to make a face

[Codehammer]

New Issues:
in Access the Modified column is Type Datetime. So In Vb it Goes sometihng like this:
row.modified = now.toshortdatestring &" " & now.toshorttimestring.

The Date Always Saves but Never the Time, it always goes to 12:00 Am. I've Tried all Combination, in putting the date without Seconds, Etc, Even manually, But it does not Work. E.G. now.hour & " " & now.minute, Stil Nothing.

Even now.tolocaltime Does not Work.

What I mean by does not work is that it Saves if I Update The Dataset, as Soon As I Will Restart the Applicaiton, then The Date is Saved, but the time Goes to 12:00 Am

[CyberHawke]

try this

Format(Now, "MM/dd/yyyy hh:mm:ss")

[mendhak]

Did you try what CyberHawke mentioned above?

I don't see why you need to put in Now.ToShortDateString and Now.ToShortTimeString.

A simple Now().ToString() will do in this case.

Post some code related to this.

[Codehammer]

Nope, the date Thing Does Not Work, it Gives no Errors on Compile, And In the program the DataGrid and dataset Shows the Actual date, After update, the Thing Resets only the Time to 12:00 AM and the Date is Correct.

The problem with the password for the Connection String still exists. Must I Now Download it from the Other Place and Respost it here.

If anyone's got time Try doing the Date thing in there.

[CyberHawke]

what is the thread id?

I do a lot of work with Access and Excel, many of the MDB files I work with are password protected and I have no problem with opening them.

As far as the date/time issue, it may have something to do with the way your table is configured. without having the actual mdb to look at, I can't help a lot, but the format function I gave you is one that is right out of a working project I have here.

[Codehammer]

http://vbforums.com/showthread.php?s=&threadid=303975

One Guy made me Search 10 Pages so I Could prove I Posted before. The database Wont Allow passwords. If you Got time Please Put in the date Properly