Solved

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

Posted on 2010-11-19
8
899 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Citrix XenDesktop 7.6 Citrix Policies Audio
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

785 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