Database Suddenly Becomes "Read Only"
I have a database on a network which has no security setup; everyone who has rights to its directory has full rights to the application. From time to time, it becomes "Read Only" and no one can do anything that requires writing to the local tables (the back end database is "Read Only" for everyone.) Checking the database properties shows the database as not being "Read Only" and changing it to read only and back again does nothing.
So far, the only way I have been able to solve this problem is to replace the "Read Only" database with a backup copy that is not "Read Only".
What could be happening here?
I have a database running for the last 6 or so years (A97) and have the ctl-shift disable enable code in it to stop people tinkering about with it.
The database was aparently working fine yesterday and today it's decided to be read-only so no-one can update the data.
It's on a server - all permissions ok and not read-only.
I can't get the disable/enable code to work either. So basically, it's locked for any development changes and it's locked for any data changes.
The IT boys are going to take a backup from the tapes of the server and re-install it, so it should be ok, but I've never had this happen before and the database is used daily for the last 6 years with no problems.
Any speculative thoughts?
 I have done a search and couldn't find anything that fitted the situation
I have an Access database that for some reason just converted to "read-only". I used to be able to open the database and do whatever, now it says it is read only. I have checked the permissions for both the database itself and the folder it is in and they both do not have "read-only" selected. What I really don't understand is if I use my application that uses the database (written in ColdFusion) I get the error - must use an updateable query. BUT if I continue to hit refresh, then it'll work! So it's like it works sometimes, but not all the time - as if it's switching back and forth between read-only and not read-only. Does anyone have any suggestions?
I have been running an access database (compiled as an MDE) over about a dozen PCs for 3 years with no problems. I have recently revamped the user interface and generally tidied things up in a new version of my database. However when I install this on *some* of the PCs it now shows the database window on startup, displaying all my tables and database objects.
I have checked all the obvious things. All the necessary boxes on the startup options are unchecked. Everything is the same as before!
The really weird thing is that some machines are doing it and some are not.
The only thing that is different from when I first made the database is that I am now using Access 2003, whereas most of the other machines are still running 2002. However I have even tried compiling the DB on a machine running 2002, and the same thing happens: some of the machines are fine, others displays the database window on startup!
I have tried searching for the answer to this without any success - please help! I really need to prevent my users seeing the database objects.
Is there any way of forcing the the database window to disappear using VB code when the startup form loads?
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
You helped me solve my linking issue with my front-end/back-end database, but I've got another question. Whenever I open up the front-end ( the shortcut to it anyway), I can't open it in edit mode- only edit. Even if I do a fileopen and select the type of open I want, it doesn't work. How do I open it in edit mode so I can link the table?
I created a database in Access and of course password protected the backend version. As a matter of course I backed up the mdb to cd in case of emergency.
Our network has been taken down due to some virus being bought in by a laptop user so I wanted to reinstall the mdb from the cd to my c: drive.
The problem is that the file is saying that it is 'Read Only' which I think is down to the password protection i put on there.
Is there a way I can get round the security?
I promise I am not a hacker!
I would like to tweak my database so that when it opens for the users it will not show the minimize, maxamize, and close buttons at the top. Also, I would need code that will maximize my forms automatically. Let me know if this is not a good idea? I am trying to eliminate someone thinking that the close button will act as a cancel button. I dont want them to save information on accident since access saves automatically! (I already have a close without saving button on every form but people are used to closing document to not save them)
How do you make an Access database able to have records written to it (NOT read only)?
I am having problems with ODBC Access data source name. When I want to display some database data in a html table on a webpage there is no problem. But when I send data from a html form to the database I get an OLE DB error. (I am using ADO). I can't remember the message exactly but it was something like
Microsoft OLE DB Provider for ODBC drivers error '80004005'
[Microsoft][ODBC Microsoft Access driver] The command must be execute on a query which can be edited.
insert.asp, line 50
For some reason my database is read-only. And I don't want that. I tried
1. ODBC administrator deleting and creating a fresh System DSN, checked if there Read-Only wasn't marked on.
2. Deleted my browser cache.
3. Restarted computer several times again
4. Installed MDAC 2.8 again.
btw. I have created the table with MS Access XP and i am using Windows XP.
Below is my code.
<FORM ACTION="insert.asp" METHOD="post">
Barcode: <INPUT TYPE="text" NAME="a1" SIZE="15"><BR>
Artist: <INPUT TYPE="text" NAME="a2" SIZE="40"><BR>
Album: <INPUT TYPE="text" NAME="a3" SIZE="50"><BR>
<INPUT TYPE="submit" VALUE="Send">
<INPUT TYPE="reset" VALUE="Clear"><BR>
a1 = request.Form("a1")
a2 = request.Form("a2")
a3 = request.Form("a3")
if ((a1 <> "") and (a2 <> "")) or ((a1 <> "") and (a3 <> "")) then
db.Open "DSN=pieter", "admin"
sql = "INSERT INTO albums VALUES ('"&a1& "','"&a2& "','" &a3& "')"
Set rs = Server.CreateObject("ADODB.Recordset")
<----- Here is the error ----> db.execute sql
Does anybody know if there is a quick way of making a database read-only (so no data input OR design priviledges).
Ive had a request to send somebody a database so they can look at the data but not add/amend etc. The only thing I can think of is adding a security workgroup and assigning read only permissions. But this seems a bit long-winded and I wondered if I was missing something obvious like a 'save as - read only' option.
This is what I would like to achieve
Each time a person comes into our building, they use a electronic key. The information is recorded into a text file. I would like to extract information as described next
The date from the line marked D. Date is marked in bold
The time from the line marked T. Time is marked in bold
The key number and Location from the line marked M. Key Number & Location is Marked in Bold
Sample of the text file:
D[ Fri 30/04/04 ]
T[ 08:19 ]
M[ Valid key:130 Ing group, tenancy:SUNCITY, door:Lower Roller Dr, panel:SURF CITY. ]
N[ 0 2 0 0 5 23 1 0 0 0 130 2 ]
D[ Fri 30/04/04 ]
T[ 08:22 ]
M[ Valid key:20 LEAD NGUYANST, tenancy:SUNCITY, shaft:0, panel:SURF CITY. ]
N[ 0 1 0 0 5 16 1 0 0 0 20 2 ]
D[ Fri 30/04/04 ]
T[ 08:23 ]
M[ Valid key:556 Ing Group, tenancy:SUNCITY, door:Lower Roller Dr, panel:SURF CITY. ]
N[ 0 2 0 0 5 23 1 0 0 0 556 2 ]
…..and so on the text goes
I am reasonably familiar with access but I have not had any experience with Text Files . Could someone post a sample db that would give me a starting point. any information would be appreciated.
I have an access database and some asp-code on my computer which only works one way?
I can read from it, but not write?
...and when I put the asp-code and the database on anohter server it works fine.
..what setting do I have to do, to make it work on my computer?
I have another asp-site with a mySQL-database on my compter which works fine...but
it doesn't work with my access-database...hmm...I can only read from it.
I have a MS Access 2000 database application stored on a Novell Network server and being shared more than 20 users. However, occasionally, different users, who want to open it in the morning have the error message The database 'Name' is read-only. Therefore, those users can NOT run any action or procedure queries/reports. To resolve, we have to disconnect all the current users, who previously open the database, then everybody can open WITHOUT the "read-only" error!!??
Please advise any permanent solution to avoid the "read-only" issue without disconnect all the users who already open the database?
Thank you so much.
When I try to run a macro to requery my form I get an error that “this action is unavailable “ and “ I may be in a read only database”??
How do I fix this?
Thank you Steven
I've created a database, and when anyone else on the network opens it they get a dialog informing them it'll be read-only, they click OK, and the startup form open as it should.
Anyway of suppressing the read-only dialog?
I have a B.E. database with 20 tables that I would like to make read only. Is there an easy way to do this?
When I zip and send out my database, how do I ensure that when the user clicks to open it, it will Not open as Read-Only?
I have a problem getting this error message "Cannot update. Database or object is read-only" in my Access form application.
The funny thing is, when i run this program under a Administrator account, it's working...but its not working with the User account.
Of course the User hast permission to this folder, it's just a folder on the "C:" drive.
Is there a special right i have to modify that the user can work on it?
I'm trying to use the transferspreadsheet command...I have the fields filled out correctly, but when I try to run the macro, it's saying that the Database or object is read only. Nothing is set to read only...any ideas?
I don't know what happened! I was successfully using my form (GALocMatEntry) which has a command button to add a new record... when all of a sudden I got the popup window saying "Cannot update. Database or object is read-only" How did that happen? How do I fix it?
Thanks for your help, Maggie
Having a bit of a problem.... I've developed a new database and this has been placed on a public access drive on the network.
There are 6 users who have full permissions, out of the 6, 4 users are working fine, can access the database, can add to tables etc, however, 2 users cannot open the database if one of the other 4 have the database open, it keeps showing the message "Cannot create lock file".
If there are no users in the database the 2 people can open the database, but then it only opens in read only... this is becoming a tad frustrating....they have full permissions, they have read write permissions set on the drive, they have been added as "power users" and still this happens......
Any ideas or help would be greatly appreciated!!!!
Thanks in advance
I'm trying to run a very simple macro that imports (TransferText) an excel file into a new db I'm creating. I get the error message Cannot update. Database or object is read-only. (Error 3027). I have another DB that I use the same type of macro, saved in the same folder, and it works fine. Suggestions?
Edited by: jansma5 on Mon Feb 7 20:19:13 EST 2005.
I have a module that sends emails based on a date. The module runs by a query, which consists of three tables, with Left Joins. If I open the query itself, I can make updates to the data, but in my code module, when it gets to the "rst.Edit" line of code, I get the "Cannot Update. Database or object is read-only". I can't figure out why it won't let me update. Below is the code .....
I have a database that's split into frontend/backend. There are approx 10-15 users on the database. They add/update/delete information using a form. I ran a compact and repair last night and this morning users are only able to add new records, they are unable to update or delete.
Can some one help me?
I'm having trouble with my database (Access 2000). I'm trying to export a file into a text file by clicking on a button. Below is the code. Where the code is in bold that is when the runtime error happens.
If i export the code manually by right click on the query > Export then this works, but for some reason by clicking on the button will not work.
Private Sub cmdExport_Click()
Dim sExportFilePath As String
sExportFilePath = DLookup("[DateExportLocation]", "tblSettings", "[ID]=1") ' Path if file to be exported
DoCmd.OpenQuery "qryUpDateTransmissionDateAndTime", acViewNormal, acEdit ' Update dates time
DoCmd.TransferText acExportDelim, "ExportFile", "qryExportFile", sExportFilePath
I appreciate your help
I create a front end and back end that resides on the lan. Front has everything besides the table which resides on the back end. Front ends table are linked to the backend. I have two computer that i am testing it on. Both of them runs Access 2003 runtime and windows has been update to the latest version, both xp machine aswell.Both has user right to read and write to that directory on the lan. Ldr exist when either of them uses access file. The strange thing is when i run a command to copy some data from one table to another one. one of the machine give me the following error "3027 Cannot Update. database or object is read only". While on the other machine it runs flawless. Another weird thing is if i modified some values in table by using forms it works great on both so i am a bit clueless where the problems is. its seems my problem is copying from one table to another. i dont have problem modyfing one table. Here is the code i use to that halt my ms access database.
Dim dbs As Database, rsProposal As Recordset, TES As String, stdocname As String, stLinkCriteria As String
TES = Me![TESID]
If TES = DLookup("TESID", "Proposals", "TESID =" & "'" & TES & "'") Then
MsgBox "Proposal Already Exists for TES ID: " & vbCrLf & _
" " & TES, vbOKOnly, "Proposal Already Exists"
If MsgBox("Do You Really Want to Create" & vbCrLf & "a New Proposal for TES ID " & vbCrLf & " " & TES & " ?", 289, "Create New Proposal?") = vbOK Then
Set dbs = CurrentDb
Set rsProposal = dbs.OpenRecordset("Proposals")
![Long_Desc] = Me![Description]
![Short_Desc] = Me![Opportunity]
![Dest_Site] = Me![Install Site]
![TESID] = Me![TESID]
![End_User] = Me![Contractor/Purchaser Name]
![Date_Due] = Me![Proposal Due Date]
![Date_Completed] = Me![Close Date]
![Status] = Me![Status]
Set rsProposal = Nothing
Set dbs = Nothing
stLinkCriteria = "[TESID] = " & "'" & TES & "'"
stdocname = "Form Prop - Detail"
DoCmd.OpenForm stdocname, , , stLinkCriteria
DoCmd.Close acForm, "Form TES - Detail"
My problems is that I am backing up files do do a complete re load of my Windows XP. I have a simple database with one form linked to one table. When I transfer to CD it saves as Read Only and I cannot make changes or delete records. I need to be able to put this back on my hard drive once my reload is complete, and then be able to make changes etc.
Probably something simple so excuse the ignorance.
I have a database on the server which is updated every 15 minutes from an external file.
Many other programs are linked to these tables and they use these tables for read-only purposes.
The problem is that when a user opens a program which has these linked tables, it locks the database on the server making it read-only, thus not allowing the tables to be updated, and important data is not available at real time.
How do i solve this issue?
I have a physician schedule database. The doctors will not be allowed to make changes so they will have a read only front end that is basically two unbound forms that allow them to search for their schedules. Are there any issues with having them all use the same front end on the network. They will be accessing it from different computers all around the hospital so it has to be on the network.
I am attempting to select records from the MSysObjectrs Table. I am using this query string:
"SELECT * FROM MSysObjects WHERE Name Like 'TURN OFF*' AND Type=5"
Everything works great when I test it inside Access, but when I use it inside my executable I get the error message:
Record(s) can't be read; no read permission on 'MSysObjects'
The executable is written in Delphi using an ADO connection to Access. This executable has no problems when calling other tables but it fails on this one.
I have a MS Access interface (front end) database on our network.
This interface is used by our interanl customers using our local network and a few external customers using Citrix. Thru this interface they have “Read Only” access to a master (back end) Access database also located on our network. The interface mdb is linked to a table in the master mdb with “Read Only” access. Only 10 of us in our dept have access directly to the master database (Update mode). It seems that when the external customers are in the interface, it puts the entire master database in “Read Only” status. As a result, I am not able to get into the master database to update it. If we have them get out of the interface, we can then update the master database. But then they can not get into the interface if I am in the master database. Thru testing I have found that this condition only occurs when the external customers via Citrix are in the interface. If an internal customer is in the interface via the local network, it does not alter the status of the master database. So from that I have concluded that it’s possible related to the access via Citrix. I've also noticed that there is no (.ldb file) created in the same directory that the database is in when customers using Citrix are in the interface database. I have the interface database setup so they can not alter any of the setting (i.e. opening the db exclusive etc). Is there anything you can think of that could be causing this type of condition to occur in relationship to using Citrix to get to the Interface Database? Thanks for any help.
Can anyone tell me why running my database from a batch file ("start MSAccess P:DatabasesNewDatabaseAlansFlexi.mdb") makes it open read-only, when starting it another way it isn't read only?