Reply
 
Thread Tools Search this Thread
 
Old 16 June 2009, 04:49   #1
RIBnet supporter
 
Erin's Avatar
 
Country: UK - Channel Islands
Town: A large rock
Boat name: La Frette
Make: Osprey Vipermax
Length: 6m +
Engine: 200 Suzzy
Join Date: May 2004
Posts: 2,830
Problem with secured MS access db

I'm having a bit of trouble with our company database when trying to access it over the network. The main db resides on our 'server' pc with a workgroup file which holds all the permissions. Until recently I could access it from any pc on the network using the appropriate shortcut which also referenced the workgroup admin file.

Since recently compacting the db (and making a couple of minor changes to permissions) I can't gain access from any networked pc. I get a message saying 'the file cannot be found'. It does exist (bloody microsoft) and it is all spelt exactly correctly, but all remote pc's fail to open the file. I can find the file by using windows explorer from all remote pc's, but of course it won't open just by clicking it because of the security settings.

Any thoughts as to why the shortcut can't see the db file?

Cheers
Keith
__________________
Erin is offline   Reply With Quote
Old 16 June 2009, 10:39   #2
DJL
Member
 
Country: UK - England
Make: Ribcraft 6.5
Length: 6m +
Engine: Suzuki DF175TG
Join Date: Apr 2002
Posts: 929
Quote:
Originally Posted by Erin View Post
but of course it won't open just by clicking it because of the security settings.

Any thoughts as to why the shortcut can't see the db file?
If you can't open it by clicking it in Windows Explorer, then the shortcut isn't going to work.

What permissions do you have on the file/folder at the moment? (You can run "icacls filename.mdb" to get a text list you can post here)
__________________

__________________
DJL is offline   Reply With Quote
Old 16 June 2009, 11:18   #3
RIBnet supporter
 
Erin's Avatar
 
Country: UK - Channel Islands
Town: A large rock
Boat name: La Frette
Make: Osprey Vipermax
Length: 6m +
Engine: 200 Suzzy
Join Date: May 2004
Posts: 2,830
Quote:
Originally Posted by DJL View Post
If you can't open it by clicking it in Windows Explorer, then the shortcut isn't going to work.
The shortcut would normally work because it includes the /wrkgrp switch to locate the security file containing the permissions. "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "Z:\General\Database\Index08sec.mdb" /WRKGRP "Z:\General\Database\Secured.mdw"

Will try icacls. Not that I've heard of it before.
Thanks
__________________
Erin is offline   Reply With Quote
Old 20 June 2009, 18:52   #4
Member
 
Bigmuz7's Avatar
 
Country: UK - Scotland
Town: Glasgow
Boat name: stramash
Make: Tornado
Length: 5m +
Engine: Etec 90
Join Date: Feb 2006
Posts: 5,068
Has any of the machines, or server been upgraded to Vista during this problem ocurrence, as all the permissions are a whole new ball game after this ?
__________________
Bigmuz7 is offline   Reply With Quote
Old 22 June 2009, 04:54   #5
RIBnet supporter
 
Erin's Avatar
 
Country: UK - Channel Islands
Town: A large rock
Boat name: La Frette
Make: Osprey Vipermax
Length: 6m +
Engine: 200 Suzzy
Join Date: May 2004
Posts: 2,830
All run XP.

Managed to solve the problem on friday by chance. Thought I'd just try dropping the .mdb file into another directory. Did this and suddenly all PC's were able to see it. Must have been some problem with having deleted the original and then renaming the replacement with the old name. The registry or whatever must have lost track of the file and thought it no longer existed.

Thanks for the assistance though
__________________
Erin is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 15:16.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.