User cannot access linked tables

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

Guest

I have a FE mdb stored in a Windows-secured folder. It has no local tables,
only linked tables. The link points to a BE mdb located in the exact same
folder. No Access security implemented.

Most of my users have no issues. Two users log into the FE, the application
opens to the first (unbound) form. When the user then tries to authenticate,
which involves a combo box with a query as its record source, Access displays
the message indicating the user has no access to that file (shows the full
url), or that file is locked for exclusive use.

We got all users off the system, verified there were no .ldb files, and
tried it again. No joy. Other users have no problem. The BE cannot be locked
for exclusive use, since multiple users can get on it at once, and at will.

Where should I look?
 
What permissions does the user in question have on the folder where the MDB
file exists? He/she requires Change access (Read, Write and eXecute are
required, with Delete being desirable.)

BTW, it's far better for each user to have his/her own copy of the FE on
his/her hard drive. If your concern is distributing changes to the
front-end, check out the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm
 
Douglas,
Thank you for your answer. I'll check out the permissions.

On the front-end issue, I'll check out Tony's application. I haven't had
any issues with the shared front end so far (at least this one....) My users
are by and large completely computer-ignorant. Giving them a shortcut is the
only way they can even successfully log in. It's a challenge, but I take your
admonishment seriously.
 
Jim, it's important that you check *every* user, not just that one. It's
likely another user that is causing the problem. You can/should actually
test the permissions by creating/editing/deleting a text file in the folder
while logged in as each user.
 
Joan, thanks for your time. I really appreciate it.

I'm not sure what you mean by checking every user. Here's the process I
went through:
1. Got everyone off the front end and both back ends (the FE links to
tables in two separate BEs)
2. Navigated to the secure folder. Open, modify, and close/save an excel
spreadsheet in that folder.
3. Open the FE (which is in that folder).
4. Click on the sole control in the opening folder (a combo box that
references a table on one of the BEs.)
5. Combo box generates the error stating the BE file (full URL) is either
unavailable to that user or is locked for exclusive access by another user. I
believe the error message is a windows error message, not an Access error
message. The other BE file had not even been referenced at this point.
6. No other users were logged into Access at the time, and no evidence of a
lock existed in that folder (no .ldb file). I was able to open the front end
and both back ends. When no one else was there, I was able to put the opening
form into design mode as well, indicating I had exclusive access. After I got
out, and the ldb's disappeared, we went through steps 3,4, and 5 again. No
Joy.
7. Reinstalled MS Access on computer used by unlucky user. No Joy.
Note: this user does not need exclusive access to any files.
 
Can you also *create* a new Excel file in that folder? I mean when you are
logged in (Windows login) as userX (not as you). You need to verify that
all users can create a file in the folder. That is what I'm thinking is
amiss.
 
Back
Top