Database opens as read only when opened from a shared location.

[JGalletta]

We have a database on a PC located on our network. The database is located in this computer's shared folder. Another database grabs data from this database occasionally. We're running into a problem where we cannot open the DB located in the shared folder (permissions granted) without it being a read only instance even with no users accessing the DB. Can anyone provide some insight into what's going on here? I may be able to provide more details if necessary.

Thanks,

John

 

[JGalletta]

Where are the create permission options located, or does this have to be programmed in? It's an extremely basic database, I don't even think the creator used VBA for anything - it's a simple form that enters data into a table. So, I guess what I'm getting at is, do I need to add a module that runs upon opening or is this an option found in the main menu?

 

[G37Sam]

He's referring to the folder which the DB is stored in. Right click on the folder and view permissions. Has nothing to do with access.

 

[JGalletta]

I'm about as close as we get to having a network administrator, but luckily I know exactly what you mean by "CRUD." I'll double check everything and let you know if that fixes it.

 

[JGalletta]

So, the file itself, and the folder it was in were granting full CRUD permissions, the problem was that the folder was inheriting other permissions from other locations, I granted permissions for all locations in the folder's lineage and the problem is solved.