• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • Last Modified:

.ldb file - a way to change the path it is set to?

Is there a way to change the directory the .ldb file is written to?  I wanted to setup some simple security for an access database on an NT server - some users in the group with full access and some users in the group with read only permission.   Do I need to use the built-in "Access" security? (I haven't spent much time looking at this but it looks more complicated than NT groups...)
0
Methos
Asked:
Methos
  • 2
1 Solution
 
BrianWrenCommented:
The ldb file must be in the directory with the .mdb file.  The ldb file is used internally by Access at the nuts & bolts level.

But this file doesn't implement security.

You need to use the built-in Access security, giving each user the pecific permissions that they are to have.

Brian
0
 
TrygveCommented:
Actually: You can use NT for security purposes. Sure: You can set permissions on the MDB files, but your users have to be able to automaticly create, update and delete the LDB files from the directory. If you have removed this permission, the MDBs will be opened exclusivly and no other user will be able to enter it :-(

So to get the security you need and get it right, use Access' own security modell. You should have a closer look at the "Security FAQ" from Microsoft. Download it using this URL http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE or read it online at http://support.microsoft.com/support/access/content/secfaq.asp
0
 
MethosAuthor Commented:
Thanks - I'll use the access built-in security and look at the faq.  I'm not really sure which answer to choose as "accepted" since you both recommend the same thing!   Is there a way to split the points?
0
 
TrygveCommented:
Not directly, but it is possible to post requests in the Customer Service area for point splitting.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now