Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WJHamel
Aged Yak Warrior
651 Posts |
 Posted - 2012-03-29 : 16:13:32
|
| Access 2010, access db.Our client has placed a password on this db (we have the password), but, in order to be able to use the db efficiently in an SSIS package, we need to remove that password. According to MS, the process for doing so is to open Access first, then open the db, but choose "Open Exclusive" from the "open" button on the dialog. Doing so should allow you to "Unset password" from the db. however, when i choose "Open Exclusive" from the dropdown on the Open button, the "Open Exclusive" option is "there" but it does not actually apply itself to the button when choose it. Sorry if it's confusing.suggestions?thanksjames |
|
|
|
|
|
Open Exclusive