ACCESSING SHARED DATABASE ON A NETWORK SHARED FOLDER

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all, setup a database within a network shared folder with full
permissions. Using the USL wizard have setup two groups "admins" and "full
data users". When the USL wizard completed its function it created a shortcut
on my desktop which works and applies the security levels i set for each
user.

My issue is that if i try and open the DB from any other computer that has
full permission rights to the shared folder the security settings are not
applied and if i try to set USL from that machine it gives me an error that
"the wizard can not be run when both logged in as admin and the database has
been previously secured" The DB is set to open as "shared" and the following
files are in the shared folder - "NBL.bak", "NBL.mdb", NBL.snp" and
"secured.mdw" I also copied the "system.mdw" into the folder bur USL still
not set. I am an intermeduate user, downloaded the "issue tracking" DB from
office website and made some modifications only. ANY HELP WOULD BE
APPRECIATED.
 
First, avoid ULS.

Second, can NBL.mdb be opened through the Start menu - i.e., without using
the shortcut?
--
********* http://panjas.org
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?
 
To answer your question, from another computer no it was not. It looked as
though the .ldb file wouldn't allow it and would open a blank DB.

Removed secured copy and just posted new copy and have not applied any
security settings. Instead of using USL, setup through tools/security/user
and group permissions? I basically have two user groups, admins (3), full
permissions (insert, update, delete but not modify DB- 35 users). Thought USL
was they way to go since i know the user DB is going to increase.
 
Back
Top