Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 921
  • Last Modified:

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

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
VigilantServices
Asked:
VigilantServices
1 Solution
 
jmoss111Commented:
check NTFS permissions
0
 
VigilantServicesAuthor Commented:
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
 
VigilantServicesAuthor Commented:
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
burrcmCommented:
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
 
VigilantServicesAuthor Commented:
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
 
pwindellCommented:
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
 
VigilantServicesAuthor Commented:
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now