Open Password Protected MDB File? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Open Password Protected MDB File?

Hi Frndz,<br /><br /> I need to access the Password protected MDB file from VB.<br />db.OpenDatabase("south.mdb<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />wd=pra"); is correct or not.<br /><br />if not then how to access this file.<br /><br />how to access the database file in n/w<br /><br />db.openDatabase("210.210.99.94/south.mdb"); is correct or not.<br /><br />if not then how to access this file
OpenDatabase("south.mdb", _<br /> False, False, "<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />WD=ur password") You should really specify the complete path to the db, but if your current directory is the directory where the database is situated, this will work.<br />-Also reffer VStudio MSDB for more info<br /><br /><br />network file – \210.210.99.94d$south.mdb<br /><br />–Rajiv
Hi,<br />true you have to use full path of db , it should be like *\srvipsharefile" <br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Many Tks for ur help
Hi <br /><br />I used this OpenDatabase("south.mdb",False, False, "<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />WD=ur password") <br />for opening database..it is working fine..<br /><br />But at the time of using this MDB file in DataEnvironment. It gives error.<br /><br />In dataEnvironment i select the database file by MSJet OLEDB4.0 Driver and enter the password for that file. After that clicking the TEst Connection, it gives error. <br /><br />The error says that "……….the file may be opened exclusivly by another user"<br /><br />Can u guys give me the solution
>>The error says that "……….the file may be opened exclusivly by another user" If you opened that DB, close it and try Madhivanan Failing to plan is Planning to fail
I guess you get this kind of error when table object of that file is opened in design mode.
So by closing the design mode can get you out of that error.
.MDB refers to the an Access database, please post SQL Server related questions. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>