Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

check if database open as readonly

Status
Not open for further replies.

MaxEd

Technical User
Jul 3, 2002
407
US
Does anyone know how to detect if the database has been open as read only? Thank you.

-Laughter works miracles.
 
Access will tell you as the app starts that you can not make any changes to this database as its read-only.

However access should allow you to fiddle with the database's attributes.

Herman
 
I need to find the boolean in ACCESS to tell me if my database is readonly to hide certain objects in the database.

-Laughter works miracles.
 
The way that i've done this is by opening a form read-only

DoCmd.OpenForm "formName", acNormal, "", "", acFormReadOnly, acNormal

otherwise there are form properties like Allowedits, allow additions and allow deletions

hope this helps :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top