By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,581 Members | 2,023 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,581 IT Pros & Developers. It's quick & easy.

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

P: 2
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
2 Weeks Ago #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.

Share this Question
Share on Google+
2 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,313
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 Weeks Ago #2

P: 2
Hi twinnyfo,

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

Cheers
2 Weeks Ago #3

Post your reply

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