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".
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
Hello, 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? Thank you!!
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?
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 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)
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.
[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> </FORM> <% a1 = request.Form("a1") a2 = request.Form("a2") a3 = request.Form("a3") if ((a1 <> "") and (a2 <> "")) or ((a1 <> "") and (a3 <> "")) then Set db=Server.CreateObject("ADODB.Connection") db.ConnectionTimeout=40 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 db.close Set db=Nothing end if %> [code]
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.
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?
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?
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!!!!
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.
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 End Sub
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" GoTo Image264_Click_Exit Else 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") With rsProposal .AddNew ![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] .Update .Close Set rsProposal = Nothing dbs.Close Set dbs = Nothing End With stLinkCriteria = "[TESID] = " & "'" & TES & "'" stdocname = "Form Prop - Detail" DoCmd.OpenForm stdocname, , , stLinkCriteria DoCmd.Close acForm, "Form TES - Detail" End If End If
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.
Hi, 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? Lynn
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 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.