471,873 Members | 2,030 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,873 software developers and data experts.

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 1661
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
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.