Source=C:1db1.mdb Persist Security Info=True' 'Provider=.4.0 User ID=sid Password=aggregate Data Use this connection string, I obtained it by using the udl method I wrote Leave the Persist Security off, or you will get a 'database is openedĮxclusively by another user' since that is required to put a password on 'Provider=.4.0 Data Source=C:1db1.mdb Jet I reinstalled service pack2 for win xp because i believd ms jet oledbĪny help or pointers regarding this would be of great help. Msjet40.dll and then i thought it might be problem with the dll itself. I checked my c:windowssystem32 directory where i found the file I have used ADODB method and used the following code.īut im getting this error when i execute it. Im trying to connect to database which is password protected.

(763) / 'sidramappa itagi via visualbasic-l' 'Jet OLEDB:System database=C:1system1.mdw' 'Jet OLEDB:Database Password=aggregate User ID=sid,' & _ Last one, I promise :) I didn't realize you were using a workgroup db. Sender by replying to this message and delete this e-mail immediately. If you have received this e-mail in error, please notify the That any dissemination, distribution or copying of this e-mail is Recipient or his or her authorized agent, the reader is hereby notified If the reader of this e-mail is not the intended Proprietary information, and may be used only by the person or entity to This e-mail, including attachments, may include confidential and/or This method not work with Office XP version.

Please respond how do i open access file with password protected Once it came time to make the switch fromĪccess to SQL, I only had to change the connection string on theĬonnection object, and nothing else needed to be done in the program. Other companies, I have migrated Access databases to SQL, and in my Well use ADO for everything to keep your code uniform. Killing off DAO, and you can't use DAO for SQL connection, so you might as Microsoft's preferred method of connecting to any database now, they are I would highly recommend using ADO as opposed to DAO. Open this, set up your connection with username and password, make sure Just make a new UDL file (create a new text doc, and rename the extension

Open encrypted mdb file