Re: User cannot access linked tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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 Wild
Microsoft Access MVP
"JimS" <JimS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2420B1C3-2F87-457D-AA0D-6E1F6C37445F@xxxxxxxxxxxxxxxx
Users in question have same privs I do on that folder. I have no prob.
--
Jim


"JimS" wrote:

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


"Douglas J. Steele" wrote:

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"JimS" <JimS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E5F774BA-CAC4-4F8C-B591-D18971F070DF@xxxxxxxxxxxxxxxx
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?
--
Jim





.

Relevant Pages

  • Re: Group permissions and cross-site groups - can you target content u
    ... Jim, thanks for the response. ... Also, this can only be used for lists & libraries, right? ... you can't assign custom permissions to an image web part ... >> called MarketingRead and add all users to it that need to read ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Default permissions for OE inside registry key...
    ... We know you lead a complicated life, Jim, but... ... > If I click on one of the other tabs in the Accounts dialog, ... > I've isolated it to being a problem with the registry. ... > so I need the permissions for the keys listed. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: MMC Message....
    ... that you may not have sufficient permissions. ... Jim, I've used defrag right there for 18 months ... By the way, if your computer shares files and folders, using simple file ... shares requires use of the Guest account. ...
    (microsoft.public.windowsxp.basics)
  • Re: Min Permissions for Pro access to Server?
    ... Dale A. Howard ... "Jim Moon" wrote in message ... >> "We wrote the book on Project Server" ... >>> It's possible that permissions have been altered in default Groups. ...
    (microsoft.public.project.pro_and_server)
  • Re: WMI permissions refused
    ... There is a reg entry to change. ... "Terry Pinnell" wrote in message ... >>either WMI or Permissions in general, ... how do I change access ...
    (microsoft.public.windowsxp.help_and_support)