Connecting to db on network drive with password

[ptuck]

I am having problems connecting to a db on a network drive with a password. The web page works fine for me from my machine, but not from any other machines. Is it possible to access a db on a network share with a passoword? The error message that is being displayed is database already opened exclusively or you may not have access. Here is the connection string I am using.

adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\networkserver\share\mydb.mdb; Jet OLEDBatabase Password=MyDbPassword

 

[CassidyHunt]

Stupid question first. You don't have the database open locally at your machine to monitor results do you?

Next I think you need to have a username like administrator or a user account inside the database to access it. If your trying to write to the database you may need to alter permissions on the folder to ensure you have the rights to access the database for read/write access.

If you need to know how to do this let me know.

Cassidy

 

[ptuck]

I do not have the db opened and there is permissions on the folder for r/w. I will try the user id. When I set the password on the db it does not ask for a id. Before when I had the id in the connection string it thought i had a workgroup file. Will try again, but if you all have any other suggestions let me know.

 

[CassidyHunt]

http://support.microsoft.com/default.aspx?scid=kb;en-us;191754

This article describes how to open an access password protected database using OLEDB

Let me know if you need more info.

Cassidy

 

[DreXor]

i mentioned this recently in another thread, but MSAccess needs change/modify permissions on the DB folder, when the DB is accessed it creates a <DB>.LBD file that is a cache/index reference, when the connection is closed this file is deleted, and hence the folder needs delete permissions on top of r/w

if the ldb has been created, without the permisssions set, then the DB cant delete the record, and hence will throw a db open error, part of how it detects if the db is in use.