Tables :: Lock View Of Tables And Queries?
Sep 24, 2013I want to lock the view of certain tables and queries so that users could not perform any change at their own. Is there any way in VB to protect it with password....
View Replies
ADVERTISEMENT
Queries :: Lock Or Disable Design View
Apr 15, 2013I am designing a database for users with little to no knowledge of Access.
Therefore, I would like to lock/disable the design view for my queries to prevent them from inadvertently making any changes to my query criteria.
Is there a way to accomplish this?
Queries :: Design View - Unable To See Relationship Tables At The Top
Sep 10, 2014While viewing the query in design view, I am unable to see the relationship tables at the top.
View 3 Replies View RelatedHow To Lock Tables
Oct 13, 2004hi,
i have created a table with 2 records.i want to lock the record such that nothing can be done with the existing records but allows to add new records.wat should i do??
thank u
How To Lock Tables
Aug 30, 2007hello to all
i want to lock the tables and queries of my database in access so the users cant modify any information
Tables :: How To View Linked Tables
Oct 29, 2013I am taking over a database someone else created but is no longer here. The tables are linked to an external oracle database. I know the links exist because when I run a query it prompts me for my user name and password. However, the tables look like regular tables. There is no icon showing it's a linked table so I don't know which tables are actually linked and pulling from the Oracle database.
View 6 Replies View RelatedTables :: Lock Historical Entries?
Oct 1, 2012I have a table of Dealers. Each dealer has a REP. I want to CHANGE the rep of the Dealer going forward but RETAIN the historical.
View 4 Replies View RelatedTables :: Any Way To Lock A Single Record From Editing?
Dec 19, 2013I use the first record of my table as a blank when the form is opened. Users are supposed to use a drop down to navigate to a record for updating. Some users have populated fields into my blank that i've had to go in and delete.
I'm wondering if there is a way to prevent that first record from being edited.
Tables :: Lock Record From Erroneous Data Entry Or Editing?
Apr 12, 2013Is it possible to have a 2 step confirmation process.
I have a yes/no control box to confirm that the record is OK or correct.
Is it possible to have a second process where by I can lock the record from erroneous data entry or editing? Like a "Post" in accounting.
Tables :: Lock Single Record In A Table To Be Read Only On Permanent Basis
Dec 29, 2014I 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 RelatedGeneral :: Possible To Lock View Design
Jan 16, 2015is it possible to lock the " view design" the user at present could run a query and the view the design and change it.
View 2 Replies View RelatedLock Table Or Configure As View Only
Mar 15, 2012Is there a simple way that I can lock a table or better yet configure it as view only. The table is used to populate a combo box in an entry form, and I do not want anyone to have the ability to add records to the table (options in the entry form), but I would like them to be able to view the table. I don't need a robust solution with passwords. I would imagine there is a simple preference to set, I am just not seeing it.
View 1 Replies View RelatedHow To View 4 Tables Via 1 Form
Jan 17, 2006Hello all,
I have an access db with 4 tables that have a common field called customer number.
I would like to do the following:
a) view some of the different fields in these 4 tables in my form,
b) update 1 of the tables via the form
Thanks for your help
2 Tables - VIEW Duplicate Records
Feb 3, 2005I have 2 tables that have the same structure and same column names - Table A and TAble B. If field1, field2, field3, field4, and field5 match - I want to see that duplicates exist.
How do I do it with 2 tables? I know the query wizard check for duplicates can do it in one table - but I need to compare the two.
thanks.
General :: How To View System Tables
Jan 31, 2013Access 2010 Where exactly do I find Import Specifications that I have created? How do you View System tables?
View 1 Replies View RelatedBe Able To View Multiple Tables In One Form Without Using Wizard !HELP!
Jul 14, 2005Hello, New to the board. I need your help/advice.
I have a: Movie Form. Table Actor and Table Director in my database.
on my Movie Form I have a combo box, where users can click on any movie on the list and display both Actors and Director information according to the Movie Title they select.
To accomplish this I use Subform/Subreport Wizard to add each Table to the Movie Form. Because When I try to bound the Specific Data to a textbox I use, the Field List is EMPTY.
My question is how can I make my Movie Form have acouple TEXTBOX's that change accordingly to the Combobox without having to use the Subform Wizard to import the info from my 2 tables.
I hope this make some sense, im just learning. Any help would be appreciated.
Thank YOU
Tables :: View Most Frequently Used Data In A Field
Jun 29, 2014How can i see the most frequently used data in a field?
For example if i have years put in a field, how can i see what is the most frequently used year and also how many times it's used? It will be a plus if i can see all the years in order.
Also if i have one field and in that field i have more than one name, can i find again which is the most frequently used name?
Tables :: Updating A Table In Design View?
Jun 5, 2013I have created a database table with 100+ fields with data. I now need to insert an additional 33 fields that will have a static default value between 1 and 33. I have already inserted the Line # field in the table between every 6 fields and gave it a default value. I now would like the existing database to update and reflect the new changes that were made for the new inserted fields.
View 1 Replies View RelatedTables :: SQL Table View Auto-number
Apr 7, 2014i have created a Union sql Table View, that i have connected to in access. Its a list from 5 different companines of Supplier accounts. I need to create an autonumber for this table? Not sure if this may be more SQL based than access
SELECT PLSupplierAccountID AS AccountID, SupplierAccountNumber AS AccountNumber, SupplierAccountName AS AccountName, 'RWL' AS Company
FROM Roth.dbo.PLSupplierAccount
UNION ALL
SELECT PLSupplierAccountID AS AccountID, SupplierAccountNumber AS AccountNumber, SupplierAccountName AS AccountName, 'FAH' AS Company
FROM FAH.dbo.PLSupplierAccount
UNION ALL
[code]...
Tables :: View Table Data On Subform?
Jan 1, 2013i have a table that holds "course codes" with the corresponding Module title and module codes, and assessment titles and codes that are used in each of the courses, so I have a few records that will go against one course code. I have forms set up with subforms, with the same general details on the top of each as the main details, and each of the subforms giving different information. But, for four of my subforms, I need to pull information from this table with the module title, module codes, assessment title and codes. possible to have these certain columns appear across four subforms, and what is the best way to go about it, I was thinking of using lookups?
View 1 Replies View RelatedTables :: Copying Data From Union SQL View
May 1, 2014I'm trying to create an access table (with a Primary key) that loads in the data from a Union SQL view.
Im hoping there is a way of achieving this? Ive tried an append and create table queries which copies the data but still no primary key.
I've created a blank table with the fields i want but cant think how to import the fields from the view into it?
Am i better off loading the view into excel?
Show Calculations In Tables That Are Entered In Form View
Jul 12, 2007I would like my table to show the result of a calculations (or a formula). I surmise that you can not have a column cell calculate data, however if I can do this in the Form View and on a Report - can it just SHOW on the Table so I do not have to keep switching back and forth to see the information.
I am new to Access and think the forum will be a big help to me.
Thanks
General :: Set Password For Tables And Forms - Allow Admin View Only
Apr 21, 2013I have a receptionist which uses a database that contains everything in the company ..there is an employee table that contains their salaries and I want to set password for this table so that the admin is the only person who can view this table .......... is that possible?? And the same thing for a form that controls this table!
View 4 Replies View RelatedTables :: Date Display Change In Table View?
Mar 10, 2014I have a table that contains many column but one of the columns is the "Collected Date". the dates entered in this column in in this format: 2013.10.28 however I to upload this table in another software to analyse, I need the date to be in this format: 10/28/2013 I already tried changing the format in the design view but since the format is currently in text it does not allow me to change the format into date!
View 1 Replies View RelatedTables :: Smooth Horizontal Scroll In Table View
Oct 19, 2012Is it possible to change the scroll type to a "smooth" scoll when I'm in table view of a table?
View 2 Replies View RelatedExtracting Common Data From Tables To View In A Report
Nov 12, 2012I have a feedback database with 3 tables, one for complaints, compliments and other. They have the standard common fields such as name, address, date received, nature of enquiry, investigating officer etc etc.A person can have more than one record in the complaints table and that same person could also have 1 one more records in the compliments and others table. What I would like to do is to be able to display the data for that same person that appears in the complaints, compliments and others table in a report using a search facility by either name or address. This will therefore display the number of times that this person has made contact together with dates and the reasons.
View 1 Replies View Related