CS
|
Posted: 01/08/2004, 3:56 AM |
|
Not sure if this is the right forum...but, I want to password protect an Access database, which I have successfully done. However, when setting it up with CCS, it's not opening the database. The error I'm getting is that it's opened exclusively by another user.
Anyone have a work around?
Thank you!
|
|
|
Edd
Posts: 547
|
Posted: 01/08/2004, 5:23 AM |
|
CS - is this the same issue as: http://forums.codecharge.com/posts.php?post_id=25226
The first thing to try is remove the password off the applicatiion and see if you can connect.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
CS
|
Posted: 01/08/2004, 6:10 AM |
|
Yes, I can connect when I do not have a password on it. No, it doesn't appear to be the same issue. I set up the connection string with username, password...and the error says it's opened exclusively by another user (which I had to do to password protect it, but then I closed out of it). Access is not still running when I'm doing all of this. I can't figure it out!
Quote Edd:
|
|
|
Edd
Posts: 547
|
Posted: 01/08/2004, 1:41 PM |
|
Evidently, this can happen if IIS can't write the Jet lock file because IUSR_MACHINE doesn't have write permissions to the directory containing the .mdb file.
Check your permissions.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
CS
|
Posted: 01/08/2004, 3:37 PM |
|
IUSR has write permissions to the directory...without a password the app writes to its heart's content! WIth a password, it's a no go.
|
|
|
Edd
Posts: 547
|
Posted: 01/08/2004, 4:33 PM |
|
Does the MS Access Database contain things other than Tables and Queries? If so try and make a MDE of the MSAccess database (microsoft recommed this) to separate Data and Programs.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
CS
|
Posted: 01/09/2004, 2:51 AM |
|
No, it's just got a couple of tables, that's it.
|
|
|
Edd
Posts: 547
|
Posted: 01/09/2004, 4:04 PM |
|
CS - Can you Register so I can give you my email address in a private message so I can get a copy of your DB and take see if I can replicate the issue.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|