473,670 Members | 2,331 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to Make DB Objects Read Only?

58 New Member
Hi all!
I have a table of which should be converted to READ ONLY after confirmations! The Confirmation Button may be set to VBA to change the table properties to ReadONLY!!!!
Please help!
Apr 23 '11 #1
5 3265
Stewart Ross
2,545 Recognized Expert Moderator Specialist
Tables cannot be set to read-only in Access.

If you really mean that you are accessing via a form you can use the form's allow edits and allow deletions properties to control whether or not users can edit the records. Although setting these properties in VBA is simple, you should be careful about how you do so as users may wish to make small changes to records after they confirm them (to correct a spelling error, for instance). I allow a short time period for this, set in a properties table for lookup and modification if required.

-Stewart
Apr 23 '11 #2
Moah Scout
58 New Member
Thanks alot Stewart! I will try your suggestion, this DB is just a trial version. It doesnt mater whether you disable it or not, we dont expect any editing after confirmation
Apr 23 '11 #3
Mr Key
132 New Member
According to my knowledge, if you link the db to another db, there are options to decide whether you want the tables to be linked as read only or not!!
There might be some trick for it
Apr 24 '11 #4
Mr Key
132 New Member
What if we create a copy of another db on the backend and delete the existing one and then create new db with no objects but include the link of the backend db wont it be the read only? I just wonders!!!!
We can also prevent the user from opening the realbackend db.
Apr 24 '11 #5
Stewart Ross
2,545 Recognized Expert Moderator Specialist
No, Mr Key, what you mention is just added complication which will not achieve what the poster requested - which is to have a table read-write until the record is saved, then read-only thereafter.

As mentioned, Access cannot set individual tables read-only, although it is certainly possible to treat the recordsource of forms as snapshots rather than dynasets (which will make them in effect read-only) - but only through the forms interface, not the tables as such.

-Stewart
Apr 24 '11 #6

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

Similar topics

3
9208
by: Greg Brunet | last post by:
In puzzling over classes, I'm wondering if classes can have read-only static properties? I certainly seem to be able to do create static properties like this: class C(object): count = 0 def __init__(self,s): C.count += 1 self.Name = s
1
5206
by: Efrat Regev | last post by:
Hello, I would like to recurse through a directory and make files (which match a specific criteria) read only. From searching the Internet, I found http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/303343 which shows how to change file attributes to read only using the win32api module. That's great, but I was hoping there's a more portable way to do so. Is there a more portable API call to make files read only? Many Thanks,
1
2035
by: samuelgreene | last post by:
Hello, I have a front-end access db on a server share - the users should COPY the db to their desktop - but we know how that goes. I've tried to make it read only and have denied execute permissions on the directory but it's still runs off the server - i just get the read only message in access. Does anyone have a solution? Why am I able to execute the db? Is a temporary copy being created on the desktop computer? I've noticed
24
41580
by: Bob Alston | last post by:
Anyone know a way to make all access to a linked table, in another Access MDB, read only? I really don't want all the hassle of implementing full access security. I can't do this at the server file system because in some front ends the user needs update access. I want to give users access to the data for reporting with their own queries and reports. I just don't want to take a chance on them
6
2663
by: BBM | last post by:
I have an object that has a fairly complex construction sequence, so I have written a dedicated "factory" class that invokes the constructor of my object class (which does nothing but instantiate the object and set default blank/null values), and then does all the Db access and number crunching to populate the new object. The factory returns the fully populated object to the caller. All the fields in the object are private, but have...
3
1855
by: jao.sanien | last post by:
Hi I have a access file that need to be made to read only. And the file should be password protected if I want to edit something. So those who doesn't have the password can only read. I don't know access at all so I don't have a clue help pls Many thanks
1
2622
by: leiger | last post by:
Hi, I need help with this problem as soon as possible (within a couple of days). This is the first time I have ever used Access 2007 and therefore I am having some problems - especially as I am attempting some things I have never used in a database before this. As you can see in the picture, I need to create a form to edit pet details. I want to use a combo box to select the owner, then (if possible) have all of the records in the...
11
49333
by: eimbert | last post by:
Hi, Im fairly new in the Access world. I would like to know how I can prevent users from changing data entered into a specific field of a record. Once I have completed the data Entry they should be able to see the information but not be able to change it.
1
1351
by: awigren | last post by:
I have already created a way to add new data in my database through a 3-step process. Now that I have all my methods of entering data set, I am now wondering if there is any way to make a "Read-Only" form or table to view the data, so that when others are using the database to look up information, nothing can be accidently changed. Thanks.
4
3733
by: sweetfalguni | last post by:
Hello, The codes below worked successfully in Access 2003 Private Sub Form_Current() If Me.NewRecord Then Me.AllowAdditions = True Me.AllowDeletions = True Me.AllowEdits = True Else Me.AllowAdditions = True
0
8907
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8817
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8593
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7423
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6218
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5687
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4396
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2046
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1799
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.