Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2010-11-19
8
Medium Priority
?
932 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
7 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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

580 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