Solved

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

Posted on 2010-11-19
8
894 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
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
Citrix XenDesktop 7.6 Citrix Policies Audio
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

762 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now