Eliminate Read Only

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
A database I created sits on the network. Someone want to modify the tables and queries, but they get a message that they only have read only rights. How can they get full access to make any changes? Thanks

Parra
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
There's two possibilities.
1- It's within Access, but you'd notice this because you were using the built-in Access security module and the user has to login when opening Access (although it's possible to set this once and not do it again)

2- (and more likely) It's a network rights to the folder where the mdb exists that is the problem. If true, the read-only message would show up when they attempt to open the database but before they can see anything.

The problem is, Access creates a temporary lock file (ldb) that exists as long as anybody has the database open. If it can't do so, (user doesn't have privs) you can't open the database.

Copy the database to a folder they control and see if they can open it from that location.

Mike
 
Upvote 0

Forum statistics

Threads
1,221,631
Messages
6,160,942
Members
451,679
Latest member
BlueH1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top