Access and r/o network share

[midnight]

I 've tried to acess an Access 2000 database placed together with .mdw file on a read only network share. I am using VBA in Excel 2000 and OLE DB.

Do I have to have the write permission on that network share to access database only for reading ?

When I gave to myself a full permissions it works fine.

Here is connectionstring I am using.

conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=V:\DBase\Base.mdb;
Jet OLEDB:System Database=V:\DBase\Groups.mdw;
user id=""odczyt"";
password=""odczyt"";"

 

[ray705]

I believe that Microsoft Jet still wants to create an ldb file for the database. When you gave full permissions, you can create and delete the ldb but not with read only.
Try your linking to the db (with full permissions) and then look in the folder to see if the ldb was created.

 

[midnight]

That database is always in use and ldb is always present.

I tried with full permissions and it's working.

But I want it works without write permission.

 

[ecniv]

Dont you put the read only bit in the connection string?

www.able-consulting.com (I think) has a list of connection strings and parts there of....


Or do you mean you only want a read only shared area ?



Vince

 

[ray705]

I may very well be wrong, but I don’t think you have a choice about the permissions.
Access is going to use the ldb file which means you must be able to create and delete within the folder. You could try adding the LockType = adLockReadOnly property to your connection.