Read Only But Can Run Queries?????
Sep 14, 2005
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)
Help
Cheers
Bikeboardsurf
View Replies
ADVERTISEMENT
Jul 26, 2007
Is it possible to make Microsoft Access queries read only without making the entire database read-only?
Thanks for your help, Steve
View 2 Replies
View Related
Jul 26, 2007
Is it possible to make a Microsoft Access Query read Only without making the entire database read only? If so, how?
Many thanks, Steve
View 1 Replies
View Related
Jun 30, 2005
Okay, take three tables.
AreaTable
AreaID
AreaName
Percent
GangTable
GangID
Area_ID
Speed
MasterTable
MasterID
Station
Description
Area_ID
The Relationships
AreaTable.AreaID 1---------> (inf) GangTable.Area_ID
AreaTable.AreaID 1---------> (inf) MasterTable.Area_ID
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.
View 2 Replies
View Related
Aug 25, 2013
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:
In(ELA,MEAP,Star Math)
In(DRA, Math, PercentileRank)
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?
View 4 Replies
View Related
Mar 28, 2014
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.
SELECT dbo_NPD_Container.PENumber, dbo_NPD_Container.JobNumber, dbo_NPD_Container.ProjectTitle, dbo_NPD_Container.Status, dbo_NPD_Sales.InitialQuery, dbo_NPD_Sales.InitialQueryDate, dbo_NPD_Sales.SpecificationIssued, dbo_NPD_Sales.ApprovalRecived, dbo_NPD_Sales.TuDrawIssued, dbo_NPD_Sales.TuDeliveryDate, dbo_NPD_Sales.TrialRequestIssued, dbo_NPD_Sales.SampleDate,
[Code] .....
View 2 Replies
View Related
Apr 16, 2013
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?
View 3 Replies
View Related
Dec 19, 2007
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.
Any ideas?
View 3 Replies
View Related
Sep 2, 2014
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?
View 4 Replies
View Related
Sep 20, 2005
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
View 2 Replies
View Related
Nov 3, 2005
How can I provide "read only" access to a specific user?
View 1 Replies
View Related
Jun 30, 2007
Hi All
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?
Anything is worth a try:confused: .
Thank you !
View 1 Replies
View Related
May 9, 2007
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
View 4 Replies
View Related
Aug 9, 2005
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?
Any info would be greatly appreciated. TIA!
--Adam
View 2 Replies
View Related
Aug 23, 2005
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.
Please help :confused:
View 2 Replies
View Related
Oct 18, 2005
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.
View 6 Replies
View Related
Oct 24, 2005
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.
chris
View 1 Replies
View Related
Dec 1, 2005
Hi all,
I have e-mailed a database and when it arrives at the other end it is read only. I sent it in a zip file.
Using MS access 2003, emailing through a corporates firewall.
Any help would be much appriciated.
View 3 Replies
View Related
Dec 9, 2005
Just upgraded to office 2003 now everytime the dbase opens I get a read only error. How do I make it stop?
Jom
View 1 Replies
View Related
Jan 4, 2006
Happy New Year All,
I know that I've done this sometime or another, but does anyone have a
code snippet for reading a Registry entry? Also, what reference?
Wayne
View 2 Replies
View Related
Jul 12, 2006
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?
Thanks for any help
View 1 Replies
View Related
Jan 2, 2007
Hi, i've a problem
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??
thx in advance
bye
View 5 Replies
View Related
Jan 16, 2007
Hi there
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.
Please help.
Thanks..
Danny
View 2 Replies
View Related
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
Mar 15, 2005
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??
thanxs in advance
View 1 Replies
View Related
Mar 21, 2005
My Access database is situated in a folder which has permissions to only let some people write into it.
The problem is that we would like users with read access to open the database to view but get the following error:
Couldnt use ...path... File already in use.
The database always has more than one user in it so this may be the root of the error message.
Solutions which cannot be implemented are moving the DB to a higher folder or giving write access to this folder to the read-only users.
Thanks in advance for any ideas.
View 1 Replies
View Related
