using DAO on a password protected workbook

L

LeShark

I have written a large add-in that access multiple files with DAO. The files
are protected so they are opened with the password before attempting access.
The Add-in is meant to be multi-user (inquiry only if not 1st user) so it
recognises if its already in use and opens the files as Readonly for 2nd and
subsequent users. DAO appears to work perfectly. However when the 1st user
closes the application, DAO fails for the other users even tho the files are
still open as readonly. The error is the usual "cannot decrypt file". Can
anybody help please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DAO on protected workbooks... come on guys 0
Exporting data with vba from Excel to an Access 2007 db with password 8
getObject and password protected workbook 4
Protect Workbook in 2003 changes to password to open in 2007 0
Can Sharing Workbook Corrupt Sheet Password? 0
Can Sharing Workbook Corrupt Sheet Password? 0
Password protected workbook 5
Open Access database(DAO) with password protected 1

Top