Hi
I've networked my database and given a bunch of People Read only access. There is a button there that when pressed runs some queries. Basically I dont want READ ONLY users to be able to run any queries. I only want exclusive users to be able to get access
How can I prevent these queries being run.
Can read only users run an UPDATE query? According to my system this may be the case.
I dont want to change my system (i.e put the button on a separate form etc)
Initially the query below used Inner Joins, however that limits my list, when i want to see ALL elements from the MasterTable no matter what, thus my inner joins became left and right joins as follows.
Simple Query: Query1
SELECT MasterTable.Station, MasterStable.Description, MasterTable.Area, AreaTable.Percent, GangTable.GangID, GangTable.Speed FROM (AreaTable RIGHT JOIN MasterTable ON AreaTable.AreaID = MasterTable.Area_ID) LEFT JOIN GangTable ON AreaTable.AreaID = GangTable.Area_ID;
This should simply display All Records in MasterTable, (Multiple Times if Necessary) listing all the elements of AreaTable that are Linked to the MasterTable, and all elements from GangTable that are linked to AreaTable. It does this, and displays them nicely. But I can't edit the fields. I get the result:
1 | Station One | Area 1 | 45% | 204 | 1000 1 | Station One | Area 1 | 45% | 304 | 500 1 | Station One | Area 1 | 45% | 404 | 750 2 | Station Two | Area 1 | 45% | 204 | 1000 2 | Station Two | Area 1 | 45% | 304 | 500 2 | Station Two | Area 1 | 45% | 404 | 750 3 | Station Three | Area 2 | 75% | 254 | 800 3 | Station Three | Area 2 | 75% | 354 | 600 3 | Station Three | Area 2 | 75% | 454 | 700
So you can see that Area 1 has multiple Gangs (204,304,404) and Multiple Stations (1,2). If you do a simple set up like this, you'll find that you can't change the Description field (Rename "Station One" to "Hello World"). It just doesn't work, no matter which way I've tried, I can't seem to make a Query that presents all the information from MasterTable and All the Information IN AreaTable and All the Information in GangTable which will allow me to also edit the fields.
Any Help would be most appreciative, I'm tearing my hair out on this one. Thanks, Jaeden "Sifo Dyas" al'Raec Ruiner
ps - It just seems that with Junction Tables and all the many to many relationship designs I have tried, you'd be able to change the non-related fields. I understand that you can't change the "ID" fields, but the others should be editable.
I have a two-column list box where the user selects multiple Test Names and Test Measures. Through VBA, I loop through and create a string of the selected items and store into two seperate variables, one for each column. I concatenate with the "In" and some parenthesis to end up with the following:
I place each of the In statements into two seperate dummy text boxes on the form. Then I point the query criteria to these text boxes.
When I run the query, I get nothing. However, if I copy and paste the In statements above from the text boxes directly into the query criteria, I get the desired results.
I changed the code to create an "Or" statement (e.g. "ELA" OR "MEAP" OR "Star Math"), but still the same issue.
why the query will not read from the text boxes on the Form?
I have a query that i use to update dates relating to jobs and at what stage of development they are in. It worked fine until I started to pull in some data (Prism) to update the user when the project is planned in to sample and when mass production starts (the field this is displayed in is not enabled). when I've incorporated this it I have no longer been able to update any field and my query has turned read only.
I routinely export queries etc from my development database to the 'live' master database used by users. Every so often I get the error message 'The database Mydatabase.accdb is read only'. Then I can't export anything to it. I don't know why it should suddenly become read only. How do I make the database changeable, and not read only?
I have a brand new database in-the-works that is causing me headaches. For some reason, if I create a query and then exit and re-enter the database, I cannot re-open that query. I get an Error 3112 (cannot be read; no read permission on <name>) and to contact the administrator or creater of the database.
I'M the creator and the administrator on this thing - so why can't I get into the darn thing? I haven't added any security features. This has never happened before on any database I've created, so obviously, it's frustrating.
Will like to check, i have a access database which can be open up by a few users.
How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?
I've just attempted to develop my first Access database which I've tested and seems to work well. I've copied it to use at another location but can only open in "read only", eliminating the ability to do further development or editing. How can I copy or open this database at another location? Thanks, EP
Pretty new to all this Access stuff but have to know how to do it for work! Doh! So heres what im trying to do...
We have a database in work that we keep all our info on our clients, but it is very out of date and the questions do not correspond with the answers we recieve from clients now etc.
I've started making up a new database as we are unable to change/edit the old one as the person who made it, left no note of the password!
I've created a switchboard page to direct the people to the specific parts of the database (e.g. there is one set up with a query to find people on a waiting list and all they do is click that and it displays their details).
Im wanting to make up a bit that you can send them out a letter, like we have set up in work. What happens is we click the button to 'Send Appointment Letter' and it goes into another sub-switchboard sort of thing and we pick what kind of letter ie first appointment, second appointment etc.
What I need to know is, how to narrow the letter down to a specific date. ie, in work a dialouge box comes up asking me to put in the date the person has their appointment on and then it displays a Report (I think) in Access which is in the shape of a letter with all their details on it including name address appointment time, date and venue.
I want to know how I would first of all:
Create the Report?? if thats what it is for the letter how to put their information into the letter? how would i find i get the dialouge box to come up and ask me to input the date ?
Im really quiet unsure and would really appreciate some help! Hopefully someone out there actually knows what I mean lol! I've got plenty of more questions by the way. If you can email me your answers please at jamesy.higgins@ntlworld.com. If you would like me to send you a copy of the database to try and work out how to do it, dont hesitate to contact me. I will email it as it is too big to fit on this post (500kb) Doh!
Please, if anyone could help me that would be great. Just even if they try and do something to it and send it back to me?
So my problem is this, when I wish to add users to my db through asp I get an Eror message that says I can't update because the db or object is defined as read-only but when I checks it, it's not a read-only.
please help. T_T this is important for my internet test at school.
I forgot to add that I looked at other threads and I can't seem to understand.. I don't have a security tab in proporties
Forgive me if this is in the wrong forum, so MODS, do what you will.
I'll come out and admit it right now, I'm a newbie here and have just started using Access2003. I'm in a city government so I need other users to be able to view and access my database, BUT I don't want them to be able to edit or change things. I want to be the Owner/Administrator of the database and no one else. I want to be the only person that can make changes.
Is this possible in Access 2003? Can other users only open it in Read-Only format but when I open it, it's editable?
There is an Access application somewhere in shared drive.
100 users open this application using a batch file which copies this database on their c: . They start using this database and the master database gets replicated real time. I am not sure if all the database are replicated as it is copied everyday ( so that each one of them has latest version of the application )
Is it possible ( I know it is :) ) but i am not able to figure out how it is happening.
Hi, Can someone help, does anyone know how I can read values from an excel file, basically I have an excel sheet that I'm doing some vba work and I need to go to the excel sheet which resides some where, read the table and apply the values in my current excel file. I hope that I didn't confuse you guys. Thanks a lot.
Hey, can someone help me out here, I want to make my database so it is read-only for all other people who use it, besides me, as I'm the only one who really is making changes to it. Would there be a way to do this, perhaps in a multi-user environment?
Also does Access have a tool to automatically backup the database at regular intervals, such as the end of a day. I thought it had that feature but couldn't find it in help.
Hi, I am trying to create a database from scratch, however I need multiple users to have access to it. I do this nearly everyday and have no issues on the LAN we use.
This week I have been struggling to create a database on a different LAN. I create the database however I get the message that it is read only when I close it and enter it again. This means that other people are also unable to open it at the same time, and when they managae, they only get read only access.
Could this be a strange unfamilar-to-me LAN set up? Or is there something fundamental that I am not doing when creating this database?
there's a database in a shared folder (two pc connected NOT in a LAN). the database is on the pc called "A", i'm in the other (called "B") ; i open the db and i've a message "read only". so i cannot enter, modify, ... how can i give to the pc "B" the possibilty to modifiy the db??
I have a MS Access 2003 DB. I need to make some changes in that but it shows me that Database is in Read Only and none of the changes can be saved. I have tried to changed the Read ONly attr. from right click and properties but that option is allready unchecked.
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.
i have a form, which consists of a tab control, in each page of the tab is a different subform. there is also a drop down list which allows users to select the record they want to view, i could lock the records yes, but i also want the same form to be available as a writeable from. on my switchboard i have 2 buttons "read only form" and "Edit form" my login system denies access to the edit form if users only have little access, so how do i make the read only form, while stil enabling the drop down, but disabling the fields for editing??
