Hey
I'm having trouble reversing my query from read only. I set the query to read only at first and then decided to reverse this process. However, when i switched back to rewritable mode, the query still dosen't let me edit, add or update data.
Why is this so?
Thanks
I know how to convert an Access database from a previous version of Access to a higher version of Access, using the shell command:
x = Shell("C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE " & Chr(34) & strOLDDB & Chr(34) & " /Convert " & Chr(34) & strNewDb & Chr(34))
However, what do I have to do to programatically revert from my current version of Access to a previous version? Is there a shell option similar to the /CONVERT choice? It would be nice if it was as simple as /REVERT
Thanks once more to you forum gurus!
Hey,
In my form, when users check check boxes, then move onto the next form, the check boxes are still checked (and therefore screws with the functionality of some objects)
I've been trying to use defaultvalue, and trying to find a procedure I can implement the function on, but to no avail.
Any help would be greatly appreciated.
My table has a yes/no field and about 10 records. I have created a form for the user to select which of the records he wishes to use - the records are displayed in a continuous form with a check box for the yes/no field. The user is to select one record by checking the check box in the record.
I know this should be obvious, but I can't see it. How can I make it so the user can only select one of the records (when he clicks on one, that one is yes and the others revert to no?
A have a query that selects a multivalue field. The query forms the record source for a subform. The text values in the multivalue field are displayed in the query, but when I save this and view the data in the subform datasheet view the values revert to the primary key values. They are 1,2,3,4 instead of the text values
View 3 Replies View RelatedHello,
I'm having a little problem with an Access Query. Simple table design, with relationships as normal, using a junction table for a many-to-many link.
Table1
Field: Area (Text)
Field: T1_ID (AutoNumber)
Table2
Field: T2_ID (AutoNumber)
Field: Value (Double)
Table3Join
Field: Area_ID (Long Integer) *Rel: Table1.T1_ID
Field: Value_ID (LongInteger) *Rel: Table2.T2_ID
Table4
Field: T4_ID (AutoNumber)
Field: Area (Number) *Rel: Table1.T1_ID
Field: Description (Text)
Query1
Sources: Table4, Table3Join, Table2, Table1
Fields: Description, Area, Value
SQL:
SELECT Table4.Description,Table4.Area,Table2.Value
FROM Table2 INNER JOIN ((Table1 INNER JOIN Table4 ON Table1.T1_ID = Table4.Area_ID) INNER JOIN Table3Join ON Table1.T1_ID = Table3Join.Area_ID) ON Table2.T2_ID = Table3Join.Value_ID;
However, with this design as it is, I cannot "edit" the Description field, or change the Area field. The entire Query becomes read only. Why is this? And how should i re-write this to allow me to use the relationships which Link Table2.Value to the appropriate Table4.Area (and display them both in one query), while allowing me to edit all the sub fields.
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
Using: Access XP 2002 (10.4302.4219) SP-2
Ok, been puzzled by this one.
I have a form with a subform in it. The subform is based on a query. It shows all my active staff. On the form i have a button that (atleast i would like that it does that) when clicked it sets the field "selected" on true on the subform.
The code behind the button works just fine, but i always get an error stating, can't change data, database or object is read only. Funny thing is, when i click on the checkbox "selected" in the subform behind each staff member, i can set it to true. Why does it not work? I tried it with selecting the query itself (qerWerknemersActief instead of tblWerknemers) and also not working. Here's the code, hope someone has a clue. Oh, in each form everything is set on yes except adding records, so it's not that change records is set to no.
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As Variant
strSQL = "SELECT tblWerknemers.Id, tblWerknemers.Werknemer, tblWerknemers.Selectie, tblWerknemers.Actief " & _
"FROM tblWerknemers " & _
"WHERE (((tblWerknemers.Actief)= True));"
Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL, dbOpenForwardOnly)
Do Until rs.EOF
rs!Selectie = True
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
Set db = Nothing
Call Form_frmBeheerDeelnemers.Requery
My problem is as follows:
User group 1 enters information into a table via a form.
This information then needs to be signed off by user group 2. I have created a query which shows the information in fields 1 to 10 which I want to be protected so they can only view this and not edit it and then have a couple of fields at the end where they can enter their name and any comments.
Simply my question is can I have a query with some protected fields and some un protected or is it one or the other? If this is not possible please suggest an alternative.
if there's a way to apply a list of items as criteria in the order listed? Say I've got a list of sales reps and I want a macro to run a query repeatedly, populating one rep from the list at a time in a field called Sales Rep.
View 8 Replies View RelatedHi to all,
I would like to ask here for advice on MS Access 2000 application.
When a user logs in, he should be able to use the Access 'Query' screen in read-only mode. In other words, he should be able to generate queries by selecting tables and columns, or using the wizard, but the results of those queries may never have any influence on the data in the database. So: SELECT queries only.
Users should be allowed to execute those queries, but are not allowed to access the tables, forms, or any other items directly.
Is there a way to achieve this?
Thank you
Ori
Hi all, I'm so tired of looking... please help me!!
I have an Access Data Access Page based on a query which is not updatable.
The query is based on a many-to-many table (e.g. OfficeProducts with foreign keys for OfficeID and ProductID and an Amount field). The query is not updatable as I have included outer joins to the Office and Product tables to get all their records back.
(I'm not sure if I've done this the best way, but need to be able to list all the possible Products for each Office whether they use them or not.)
I want the user to be able to update the Amount field, so e.g. if it is currently set to 50 to be able to change it to 40, or if it is currently null (as there is no record so far for that OfficeProduct) then to insert a record into OfficeProducts with the OfficeID, ProductID and Amount value entered.
I thought this would be straightforward by creating a new textbox in the same section as the current Amount field, calling it NewAmount and letting the user update this, fire an event trigger to either update or insert into the table, and refresh the query and record on the form/DAP so that Amount shows the newly updated/inserted value.
I have been searching for ages... cannot locate either the best event or events to use for this nor the code to enter!! Please please help!!!!!
(This is actually for a charity helping people suffering from emergencies in developing countries, not OfficeProducts, so your spot in heaven will be reserved if you can help ;) Thanks)
Jen
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?
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] .....
I have an access program that is stored on a SharePoint site. I want to be able to export report to the computer even if I just open the access program as read only. Here's my code:
Code:
Private Sub btnExport_Click()
On Error GoTo btnExport_Click_Err
Dim db As DAO.Database
Dim strSQL As String
Dim qdfTemp As DAO.QueryDef
Dim qryFilter As DAO.QueryDef
[code]...
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?
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
How can I provide "read only" access to a specific user?
View 1 Replies View RelatedHi 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 !
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?
Any info would be greatly appreciated. TIA!
--Adam
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:
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
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.
chris
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.