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.
I'm a SQL Server DBA and have a few Access 2010 Db's to look after and occasionally have to make amendments to (as is the case today). I've been asked to apply permissions to certain users of the Access database whereby users in a group we're calling 'Viewer' only have read permission and users in another group called 'Writer' (original I know!) have both read and write permission.
The database is form driven (i.e. no-one directly accesses and amends the tables in the database), the file is saved with a .mdb extension.
I've played around with the 'Manage Users & Permissions' in the File Menu however these don't seem to do what I need them to and only result in having to input a user and password to access the database on start-up.
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 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)
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??
What's the easist way to set a record in a form to read-only if a check box is ticked? When going from one record to the next, the user needs to facility to change a record only if the tick box is empty.
i burned a copy of my database to a cd. now when i open the database ity says that it is read only and will not let me do any editing. i never seen this before anyone know why? and how to correct this
I have a ASP Page which reads data from an Access database. I Have and Access Database and a Excel Spreadsheet. The spreadsheet contains all of the up to date data whilst the Access Database contains old data. Is there a way that i can get Access to Update its data with the data from the Spreadsheet? As the spreadsheet is updated all of the time. I do not have much knowledge in Access.
