Help - Security Issue

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

Guest

I've put this question in here before, but have not resolved my problem. I
have a split database, with the back end out on a server. The front end is
on all user's individual PC's. I also have a security mdw which I've
created and seems to work fine. The problem I'm having is if more than one
person tries to open the database, they receive an error message saying
"Cannot access the FILENAME, file already in use." What do I do? I was
told that users should have full permissions to the shared folder which holds
the back end. I have now had that set up, but the problem has not been
resolved. Any ideas?

thank you,
Janet
 
'Had it setup' implies that you had someone else do this. You need to
verify that *all* users have this permission.

You can verify, by having a user open Windows Explorer, and attempt to
create a file in that folder (just right-click, New, text file will do). If
they can create it, can they save it? Can they then delete it?

If this checks out, it's possible that things weren't cleaned up from the
previous problem.

With everyone out of the mdb, check in the folder to see if there is any
file with a ldb extension. If this file(s) exists, delete it(them).

Also ensure that your mdw file does not have the same name as the mdb in the
same folder. They each need to create an associated ldb file; with the same
name they can't.
 
Hi Joan,

Yes, I had network people set up the permissions on the folder. As to an
ldb file, there isn't one in the folder and the mdw file is named differently
from the mdb. I did notice, though, that when I open the database an ldb
file only shows up for the mdw file out on the folder and for the mde file
(front end) on my C drive (where it is stored). Shouldn't there be one for
the back end (data) as well?

thanks,
Janet
 
When you open the mde, you haven't yet necessarily opened the backend mdb.
Once you open a bound form, you'll see the ldb show up for the backend.

Have you tested that the network people set things up correctly?
 
Hi Joan,

I just heard from one of our network guys (a different one than who had set
up the permissions initially) that they were indeed still wrong and he has
fixed it. I just tested it as you suggested and it works fine. Thanks for
you help on this.

Janet
 
Back
Top