var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: VB5 and Access2002 for encrypted mdb file does not work
Problem : I used the security wizard on an .mdb file. My previously working connection from VB5/ADO2.5 isn't working anymore.
(A) Thru SQLOLEDB :
Connection string = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\DataStore\Kukumatz.mdb; "
strSca = strSca & "Initial Catalog=Students; User Id=Sori; Password=alfabeta; "
I get the following error :
"Multiple step OLE DB operation generated errors."
(B) Thru ODBC (with a registered DSN) :
Connection string = "DSN=Tilda; UID=Sori; PWD=alfabeta; Initial catalog=Students "
I get :
"Could not find file (unknown)"
although I indicated the database name when configuring the DSN.
What am I doing wrong ??
Re: VB5 and Access2002 for encrypted mdb file does not work
What exactly di you do with the Security Wizard? If you set a database password, and the database is not workgroup protected, the connection string should be:
Connection string = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\DataStore\Kukumatz.mdb;Jet OLEDBatabase Password=mydbpassword;"