Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #11 (permalink)  
Old October 13th, 2003, 01:27 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Connersville, Indiana, USA.
Posts: 126
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Ah hah!
I think you are on to something Bob! Here is what I did....
I opened the database....had another lady in my department open the same database...it worked fine.
I opened the same database and had a different lady from another department open it too and she received the error message. The first lady and I have been made trustees of the folder above where the database is located. The second lady has been given read & modify rights to the folder where the database is stored. All three of our Access XP settings are identical, therefore, the way security is set within Novell must be causing this issue.
I haven't looked on the Novell site yet, but if I find anything, I will post it here as an FYI incase any of you see this issue in the future.
I appreciate every ones help!!!


Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
Reply With Quote
  #12 (permalink)  
Old October 28th, 2003, 02:25 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Connersville, Indiana, USA.
Posts: 126
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Hello all!
I said I would let you know what I found out about this issue. Here is Microsoft's list they sent me of things to look at:
Quote:
quote:Before we begin, there are a couple of logistics I would like to make sure you understand that go along with this support offering. With the Web Response support offering you have chosen there could be a 24-hour response time after receiving information from you and phone support is not included as an option with this support offering. If this offering will not fit your needs please let me know as soon as possible and we can determine what may work better to fit your needs. Also, we are limited to provide technical support for several issues in just one incident. If you have several issues, it is better if you can open up some new cases so that our engineer can help you with them in a timely and manageable manner.

In your case you've indicated you are using Office XP with some Office
97's. You use Windows 2000 mainly, a few Windows 98 and Windows NT 4.0. Your network is Novell Netware V6. You receive the following errors:
"The table 'MsysAccessStorage' is already opened exclusively by another user, or is already opened through the user interface and cannot be manipulated programmatically."

We shall be working to resolve this specific issue through the course of the case. If I have misunderstood your concern please let me know.
Before we go any further, would you please help collect the following
information?
1. Does the database reside on a Netware Server? We have seen the
exact same error message when the database is on a Netware Server. Our
customer has reported this issue to Novell, and Novell think it is
NetWare Operation System problem. If this is the case, I would highly
suggest that you contact Novell for more information.

2. MSysAccessStorage and MSysAccessObjects are system tables. We
would suggest that you turn off the "Show system objects" option in
Access so that no user will open these system tables in user interface.
You can go to Tools->Options->View to see the options.

3. Please make sure you have the latest Novell Client installed on all these client computers. We have seen database corruption issues and performance issues with old version of Novell Client.

4. Do you have the latest Jet Engine and Office XP service packs
installed on these computers? Please refer to the following article to
make sure all these computers have the latest patches installed:

http://office.microsoft.com/ProductUpdates/default.aspx

http://support.microsoft.com/default.aspx?kbid=239114

5. It is not recommended that we use an Access 97 database in an
environment with both Access 2002 and Access 97 running. We would highly suggest that you run the database in a pure Access 2002 environment or a pure Access 97 environment.

6. For Windows 2000 computers, please make sure you have applied
Windows 2000 SP4, which handles Opportunistic Locking better.
Also...
We (our IS guys) came up with this that seems to be working so far:
Quote:
quote:These steps are only for Novell Clients on Windows 2000 PC’s

Your computer will need to re-boot after this is completed

1.) Close all programs on your computer
2.) Right click on “My Network Places”
3.) Left click on Properties
4.) Right click on “Local Area Connection”
5.) Left click on Properties
6.) Double left click on “Novell Client for Windows”
7.) Left click on “Advanced Settings” tab
8.) Left click on “File Caching” in list box
9.) Change “Setting” drop down box to “Off”
10.) Left Click on OK
11.) Left Click on OK again
12.) Computer will re-boot.
Of course the 1-12 steps are for our setup & environment.
Here is our set-up as listed above:
We use mainly Office XP, but still have some 97's. We also mainly use Windows 2000, but still have a few 98s and NTs and our network is Novell (v6).


I wanted to pass along this info because 1.) I said I would, and 2.) If I had this issue, then someone else is sure to have it to. Now that we all have this information, maybe the next individual can get it resolved in a shorter amount of time....
Oh, and by the way, to Bob Bedell...as an update on the security you suggested we look at. I was hoping it was this that was causing the issue (because it would be an easy fix), but we gave several people all identical network clearance, and still had the issue.

If anyone has any questions or wants any more information on what all we did and looked at, please feel free to contact me!



Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
Reply With Quote
  #13 (permalink)  
Old March 29th, 2004, 02:07 PM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

We're having the exact same issues w/ Access on a Novell 6 network. We have mostly Windows 2k for OS and Office 2000. We are seeing the issue on various users and various DB's. I have yet to contact either Novell or MS...

FYI that the file cacheing turned off did not work for us. Its starting to get irritating so our next step may be to contact one of the 2 big uns. Just curious if anyone has any more info on this issue.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
very urgent:cals table to indesign table using xsl franklinclinton XSLT 1 December 16th, 2009 03:48 PM
Populate a List Box with Table Names & Table date hewstone999 Access VBA 1 February 27th, 2008 10:10 AM
(oracle 8i)Alter Table <table> coalesce partition combo Oracle 3 October 13th, 2004 09:35 AM
Unlisted book and non-existent code mysorian Wrox Book Feedback 2 June 23rd, 2004 12:19 PM
size of table (type table is table of number) MikoMax Oracle 1 November 19th, 2003 03:11 AM



All times are GMT -4. The time now is 05:25 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.