473,233 Members | 1,602 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,233 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 1765
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

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

Similar topics

2
by: Jen F. | last post by:
I have inherited a medical database in which there are multiple values stored in a single field (ie. "Current Conditions" field might contain 1-20 different conditions, separated by comma (ie....
6
by: QT | last post by:
Dear sirs, I want to create panel or label field for each database records. I am using following codes for each database row to create panel field. 'Panel ' i = 1
3
by: Solution Seeker | last post by:
I want to Store the String value with Single Quotes in the Field of Database where if i try to Store the String value with Single Quotes (as it is) then it is throwing the error as SQL String...
1
by: Samuel Shulman | last post by:
Any method to make a cell editable programmatically The problem is that if the user entered a value which is not valid then instead of ignoring the value and explaining the user what was wrong ...
9
by: sellcraig | last post by:
Microsoft access 2 tables table "data main" contains a field called "code" table "ddw1" is created from a make table query of "data main" Goal- the data in "code" field in needs to...
1
by: praveen1983 | last post by:
Is it possible to make a text box readonly through Javascript
4
by: Sammatter | last post by:
Hi I need some help on how to make a field in my database unique using VBA only. I am not allowed to make it into an AutoNumber and I have no clue. Would appreciate any help given ASAP, thanks.
1
by: travjbad1 | last post by:
I am having a problem with a report. I want an entire row to shrink up to save space if all the fields in the row are null. I understand that you can use the "Can Shrink" to make a single field...
1
by: deepubalakrishn | last post by:
I have a datagridview with a template field. How can i make that field as ReadOnly when I load the grid in Web Forms. " dataGridView1.Columns.ReadOnly = true; " works only for Windows Forms...
5
by: Doicare | last post by:
Hi all I am facing a problem in storing an array of integers to an OLE object field in the database, the used code for this action is listed below: Sub Import_data() Dim oAccesss As...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.