.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...)
MethosAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.