469,090 Members | 1,203 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

How to make a single field editable in a read-only database

Hi there,

I have been tasked with updating a bespoke Access Database which can open in either read only or read-write mode.

The mode is governed by a password. Entering the password gives full access, not entering the password causes this macro to run:

Form name Client information
View Form
Filter Name
Where condition ==[Company Name]=Forms![Homer]![company search]
Data mode read only
Window mode normal

So a missing/incorrect password opens a variant of the form which has featuring a command button with the above script.

There is a single field called Notes which I would like to make read/write when the rest of the database is read only. The field properties in the data tab are Enabled = Yes, Locked = No but the data mode in the macro overwrites this.

Is it possible to allow this field to be editable when the rest of the database is read only as per the macro?

Thanks in advance for your help
Nov 26 '19 #1

✓ answered by twinnyfo

Gutbarger,

Welcome to Bytes!

Unfortunately, when an Access DB is opened in read-only mode, it affects the entire DB.

There are ways to control which specific data may or may not be edited by a user, but only when the DB is in read-write mode.

Looks like you will need the correct password.

2 1327
twinnyfo
3,653 Expert Mod 2GB
Gutbarger,

Welcome to Bytes!

Unfortunately, when an Access DB is opened in read-only mode, it affects the entire DB.

There are ways to control which specific data may or may not be edited by a user, but only when the DB is in read-write mode.

Looks like you will need the correct password.
Nov 26 '19 #2
Hi twinnyfo,

Thanks for your reply. I thought that might be the case but i just wanted to check with an expert.

Cheers
Nov 26 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Samuel Shulman | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.