×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Shared Toolbox folder permissions

Shared Toolbox folder permissions

Shared Toolbox folder permissions

(OP)
I am attempting to set up a shared Toolbox folder for all our users and am encountering problems accessing the Toolbox database.  I am seeing two different errors pop up:

1)Unable to open master database due to the following database access error:

The Microsoft Jet Database engine cannot open the file 'path-to-shared-folder\SWBrowser.mdb'.  It is already opened exclusively by another user, or you need permission to view its data.

2) Unable to open master database due to the following database access error:

Could not lock file.

The problem doesn't lie in the network (at least not exclusively) because users can open existing assemblies which contain Toolbox parts and find the Toolbox parts in the correct location.  New Toolbox parts just cannot be added - in fact, there is not even a Toolbox tab in the feature manager despite having the Toolbox and Toolbox browser add-ins checked.

It's my opinion that I have permissions on the shared toolbox folder messed up - does anyone know what they need to be?  Per the help file on sharing one Toolbox among several users, the Toolbax parts themselves need to be read-only, but what about the other files, specifically the database files?

Thanks,
Dave Gowans

RE: Shared Toolbox folder permissions

(OP)
I have been following the document you referenced.

I have gotten past the database errors by opening up all the permissions of the shared Toolbox folder, with the exception of the Toolbox parts themselves, which are still read-only.  Now, the Toolbox is available, but users are having issues inserting Toolbox parts into their assemblies:

Unable to open read-only file \\path-to-file\xxxxxxx.sldprt

Again, the network location is available, but there is a setting I'm missing.

Again, any information is appreciated.

Thanks,
Dave Gowans

RE: Shared Toolbox folder permissions

If you set the setting uder the Toolbox\Browser\Configuration for each user? - In the drop down menus of SW.

"Always Change Read-Only status of Document before writing"

You have also selected "no copy (always use master part file)""

Regards,

Scott Baugh, CSWP
http://www.3dvisiontech.com
http://www.scottjbaugh.com

FAQ731-376

RE: Shared Toolbox folder permissions

(OP)
Scott,

I do have the Browser configuration settings as you described.

Any other ideas?

Thanks,
Dave Gowans

RE: Shared Toolbox folder permissions

(OP)
What do you mean by the server permission?

The permission on swbrowser.mdb is NOT read-only.  I opened up the permissions on the .mdb and .ldb files in an attempt to eliminate the master database errors I was getting (see my original post).  Does this need to be read-only?  If so, will I not end up chasing my tail by fighting through master database errors?

Sorry for any confusion....

Thanks,
Dave Gowans

RE: Shared Toolbox folder permissions

(OP)
FYI,

I changed the permission on swbrowser.mdb to read-only and am now getting the following error:

Error: \\path-to-file\swbrowser.mdb has read-only file attribute

What gives??????????????

Thanks,
Dave Gowans

RE: Shared Toolbox folder permissions

(OP)
Problem solved.  I needed to open the permissions on the network share so that the users had read/write access to the shared Toolbox folder.  The individual part files still have read-only access, which is OK.

Just wanted to post this in case someone else is struggling with the same issue.

Dave Gowans

RE: Shared Toolbox folder permissions

Hi, Dave:

I have the same problem.  What do you mean that you need to open the permissions on the network share so that the users had read/write access to the shared Toolbox folder?

Thanks,

Alex Chen

RE: Shared Toolbox folder permissions

(OP)
Alex,

I had to modify the permissions on the shared folder itself through the Control Panel:

Control Panel -> Administrative Tools -> Computer Management

In the Computer Management window you will see Shared Folders under System Tools.  Expand Shared Folders and you will see Shares.  Click Shares and the right hand pane will show all the shared folders on the computer.  Right click on your shared Toolbox folder and go to Properties.  In the properties form you will see tabs for Permissions and Security.  If I remember correctly, I needed to give everyone full control in the Permissions tab.

Hope this helps.  Post again if this doesn't solve your problem.

Dave Gowans

RE: Shared Toolbox folder permissions

Alex & Dave,

The folders the parts sit in need to `Full Access' rights to the Toolbox users, and just the *.sldprt files, have the file property in Windows Explorer set to `Read-Only'.  (not to be confused with setting the file permission to [x] Read Access, in XP, 2000, NT.
The Toolbox software changes the File Attribute on the fly as needed to create any newly referenced size configurations, but cannot change actual file permissions.  (It is enough to prevent accidental deletion or damage of the source part files, and to allow for multi-user access.)

Otherwise what happens is that temp files that are created as users change fastener configurations, cannot be deleted and pile up in the directory.  Users eventually end up getting locked out of their hardware parts.

Also be aware that if you are using a basic XP machine as the Toolbox data location rather than a real server, and `Simplified File Sharing' is set in the Win Explorer folder properties, changes to file permissions will not actually take effect.  You will also be limited to a max of 10 users.

FYI,

DesignSmith
www.DesignSmith-Services.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources