Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Access 2003 - shared database keeps coming up as read-only for 1 server

Posted on 2010-11-19
8
Medium Priority
?
914 Views
Last Modified: 2012-06-21
We have 3 Citrix servers all of which have Microsoft Office 2003. For about a week now, one of the Citrix servers that tries to access a shared MS Access database for people to update is now coming up with a pop/error saying the database is coming up as read-only.

Error:
You must have a database open to create custom toolbars, and the database can't be read-only.

I have rebooted the machine several times to disconnect anyone that may have kept the database open for an extended period of time without closing it. I have tried re-installing MS Access 2003, not all of Office 2003 because I didn't think it was necessary since it was Access coming up with the pop-up only. After doing so, I rebooted and re-installed, still get the error.

Is this starting to seem more like a permissions issue on the Citrix server? I have tried Googling this issue and I could not find a similar issue to mine.

The other Citrix servers do not have this problem. Each server is running the same build and version of Access 2003.
0
Comment
Question by:VigilantServices
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 18

Expert Comment

by:jmoss111
ID: 34177018
check NTFS permissions
0
 

Author Comment

by:VigilantServices
ID: 34177161
The permissions are identical to the permissions on the other servers. I am referring to the permissions for the Access DB file. Is there something else I should check for permissions?
0
 

Author Comment

by:VigilantServices
ID: 34199820
I have just re-installed MS office 2003 professional without the updates on the server and I still get the same error. I'm assuming that this might be a permissions issue but the permissions that I am looking at are pretty much identical to the other servers, unless I'm missing a different set of permissions somewhere on the server or the file itself. please advise.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 28

Expert Comment

by:burrcm
ID: 34220814
Sometimes the file open command gets mixed up. Try opening Access, then File - Open, navigate to the mdb and click once to highlight, don't open it. Then click the arrow next to "Open" below and select open from the list. This should allow a normal open. Also check the directory where the mdb lives with everyone logged out. If a lock file still exists, delete it.

Chris B
0
 

Accepted Solution

by:
VigilantServices earned 0 total points
ID: 34222402
Okay, here is what fixed it.
Uninstalled Office completely on the problem Citrix server.  Ran the registry clean tool to remove all Office entries.  Reinstalled, patched, and added customizations and everything is back to normal.  Since we cleaned out the entire registry, we don't know which one was the offending key.
0
 
LVL 29

Expert Comment

by:pwindell
ID: 34224154
How the MS DB is handled and created can also be part of the problem.  If you aren't doing it correctly the problem may return.

Access MDBs must be split using the Database Splitter found with MS Access. It is to be split into two files,...one for the Front-end (User GUI) and one for the back-end (Tables with the data).

Without splitting it,...the first user to open it gets both read/wirte access,...the 2nd, 3rd, 4th, etc,..user only gets to open it in read-only mode.  This is normal and expected behavor.
0
 

Author Closing Comment

by:VigilantServices
ID: 34255675
The last thing we wanted to do was uninstall, but we were under the gun so that's what was eventually done.  It was better than rebuilding the entire server, however.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question