473,320 Members | 1,744 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,320 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 1772
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
1
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.