Make Tables Read Only

Jun 17, 2005

can anyone plz tell me how to make a table read only to prevent users from changing the records in the table?

View Replies


ADVERTISEMENT

Tables :: Password Protect A Linked Table Or Make It Read Only

Nov 14, 2012

I have a table that I imported from another database. I used import Access - Link to the table source by creating a linked table. - then downloaded in my database.

I want to use the linked table to create relationships and forms but do not want to even accidently edit it. The table gets updated in the database on a weekly bases and I am hoping it gets updated automatically in my database as well. does it automatically get updated or do i have to set up something?

Also, I want to protect the data in that particular table and either password protect it or make it read only. Can I do that? If so, how?

View 4 Replies View Related

How To Make Read Right To Left

Mar 18, 2005

I have a field within the table in hebrew and want to make it read from right to left. How can I?

Will that be working if I display it using ASP online?

View 1 Replies View Related

Forms :: Make Record Read Only

Jul 11, 2013

I have a Workorder form that I want to not allow edits, deletions, and additions when the Workorder is closed. Is there a way to program a button for this that could be password protected in case it needs to be reopened?

View 3 Replies View Related

Ms Access Read Only Html Format - How Do I Make One

May 14, 2007

Hi im kinda a newbie here so, any helpful comments or links of creating a ms access database where it can be viewed in html is welcome. thanks

View 1 Replies View Related

General :: How To Make Database Accessible (read Only) On Other Pc

Sep 15, 2014

how to make my database accessible (read only) on other pcs?

View 7 Replies View Related

Tables Read-Only

Apr 16, 2007

I believe I may have asked this question before but…

I have a FE/BE database. Is there a way to set the tables as “read only”? I’d like the FE to be read only, but allow users to see all the tables, not just forms etc. However, if they open the BE, they would have full control.

Thanks,
SKK

View 6 Replies View Related

Allow Combo To Read From 2 Tables

Apr 8, 2006

Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:

If Me.OptionGroup = 0 then recordsource = "Asset Categories"
Else RecordSource = "Consumable Categories"
End IF

Any Help Please

View 3 Replies View Related

Need Data In Tables To Be Read-only

Dec 30, 2004

Hey all, I need data in a table to be read only, once its inserted no one will be able to modify with the exception of a admin,
how can i go about doing this/.

thanks!

View 2 Replies View Related

Allow Combo To Read From Two Tables

Apr 8, 2006

Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:

If Me.OptionGroup = 0 then recordsource = "Asset Categories"
Else RecordSource = "Consumable Categories"
End IF

Any Help Please

View 3 Replies View Related

Tables :: Read Only Record?

Jul 11, 2013

I have a Workorder table and a Workorder form. I would like to be able to make a Workorder closed when it is finished so that it is read only. I have a finished date field so maybe by entering a date there could be a way to accomplish this?

View 4 Replies View Related

Tables :: Read Value From Field?

Dec 7, 2012

I define one Field in Table with 3 different Values form another Table. But now I dont know how to extract that values.

View 4 Replies View Related

Read Only Access To Appended Tables

Apr 30, 2006

Hello! My Small access aplication has a tables appended from dbf database program. I am coping with an issue to set access to this tables as read only.For me its very vital that source dbf application won't be changed from MS Access.Thanks for help!

View 3 Replies View Related

Linked Tables Across Network Are Read Only

May 22, 2006

I have a main computer where my Access Application runs but I also want other computers with the application runnign on it but linked to the backend database on the main computer, however when linking to the tables they are only read only.

How do you link to tables accross the network so you can read and writ e to them?

View 5 Replies View Related

Tables :: Open Table As Read Only

Jun 27, 2013

I want to be able to open a Table as Read Only, so that a user can browse etc., but neither alter nor enter data - I want them to use the Forms for that. How then, using VBA code, do you open a Table as Read Only?

View 14 Replies View Related

Need Help With Updating Number In Tables (read Post For More Info)

Sep 13, 2007

I am new to Access, so bear with me.

I am using Access 2007.

I have 4 tables created, and they are breaking out information for recording files that are being created from a PBX.
The tables are created as thus:

tbl_1
Key:ext_id | extension

tbl_2
Key:loc_id | location

tbl_3
Key:f-type_id | filetype


tbl_4
Key: mass_id | filename | date | loc_id | ext_id | f-type_id


Now I have created the relationships between the tables for the various ID's. My issue is the following:

I will be automating this process, so when the data is imported to the various tables, I need the relevant keys from tbl_1 tbl_2 and tbl_3 to be added to tbl_4 when the new data is brought into the tables.

As to the process of importing the data, I was looking at using PHP to facilitate this. Any ideas, help or direction would be greatly appreciated. I have looked around the net for an idea of how to solve this, but, being so new, I am not exactly sure how to word the question.


Thanks!

View 2 Replies View Related

Tables :: Read A File And Import Its Data Into A Table?

Oct 17, 2014

Was wondering how i can import data from a file to a table in different fields. The data inside the file is described with the number of characters and space's between. The attached file has the data.

For example in the file attached, the first four characters represent a data like 'ticket number' and maybe the third line 6 to 10 charcaters represent 'name of a passenger'.

Now how do i import these data to a table into respective fields in a table.

View 14 Replies View Related

Tables :: Lock Single Record In A Table To Be Read Only On Permanent Basis

Dec 29, 2014

I want to "lock" a record in a table so that it is read only and cannot be accessed/edited/deleted. Is it possible to lock a single record in this way on a permanent basis? It's actually the first record in the table.

View 5 Replies View Related

How To Make Tables Visible

Apr 6, 2007

hey guys i was just wondering if anyone knew the code to make a table visible via changing a combo box. i know for a form its simply
Form_formname.visible=True

View 2 Replies View Related

Tables :: How To Make A Certain Field

Oct 25, 2013

i have a table called students with the following field:

Name
Surname
Address
Class

I want to create another field in the table called summary where i can create a default for that field to place the [Name] & [Surname] & [address] & [Class].I have now done it in expression prob being it wont let me add a number field or lookup field.

View 5 Replies View Related

Combining Tables To Make One Big Table?

Oct 11, 2006

Hi

I have several small tables that I want to make combine into a big table.

How do I do this - is the only way by using a query?

Maria

View 2 Replies View Related

Tables :: Make Default Value In One Field

Aug 13, 2013

I am doing a project for school. I would like to make the default value in one field (available or rented) to be "rented" if the value in a field in another table is null. Is there an "easy" way to do this?

View 2 Replies View Related

Tables :: How To Make The Field Unique

Dec 13, 2013

I have downloaded a contact template from the internet ready to go. There are few things I need to get rid off and make changes to.

One of the most improtant thing is making one of the field unique. For some reason, i can get to the design view. I open navigation panel and right click on the table, there is no such thing call design view on the menu.

View 6 Replies View Related

Tables :: Make Table Queries - Indexing?

Jan 2, 2014

I have a complex series of calculations to perform, and I have found the best way to achieve my end is to create new tables by the Make Table queries.

The trouble is I have many tables to create and the downstream tables refer to the previously created tables; I have recently discovered that queries perform much quicker if they are indexed (duplicates OK). I've looked at my tables created by the MakeTable queries, and they all seem not to be indexed.

How do I make them indexed automatically?

View 2 Replies View Related

Tables :: Make Query Temp Table

Oct 9, 2013

All using access 2010. I have a multiuser database that I feel would benefit from splitting into a backend with multiple user frontends. My problem is that there are tables from make table queries processed every two weeks that all users need access to. As far as I know; you can not put a table in the backend that you will delete and remake or a temporary table and link to it in the front end. Is there any other way I would be able to split the database and have temporary tables linked from backend to frontend that I am not aware of? Is there another way to creating temporary tables and tables from make queries? This database has 9 users and counting and really needs to be split. r

View 14 Replies View Related

Modules & VBA :: Make Smaller Tables Out Of A Bigger One

Jul 30, 2013

I have a table with 3 fields. The fields are down1, down2 and down3. . I would like to use this table to create a new table (downtime). What I need too do is loop through each record in the table and place the three fields independently in my new table. For example, I would like to go to the first record in my original table, than place down1 as my first record in my new table, down2 as my second record and down3 as my third. Than I will go to the second record in my original table and place down1 as my fourth record, down2 as my fifth record, down3 and my sixth record and so on.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved