Re: Issue with path / permissions for linked table

It doesn't have to be this issue, but last time experienced it, the network had been setup wrongly. There were mutiple shares to the same folder, one of which was read-only. The drive letter was assigned wrongly on the machine that got the error.

If you are certain it's not that issue, perhaps someone else can suggest something.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ormazd" <ormazd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F8A43BA2-ECF6-4E28-B564-90649E60A618@xxxxxxxxxxxxxxxx
Right. But, the users don't have permission issues when using the S: drive
path to the same table. Only when using the UNC...?

"Allen Browne" wrote:

The UNC path is generally the best solution.

You can get that error message if the user does not have adequate
permissions on the share. If they don't have permission to create a file,
Access can't create the LDB, and you get that message.

to group, rather than allenbrowne at mvps dot org.

"ormazd" <ormazd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:723B2750-18BC-4D11-81EE-9ED47E002E69@xxxxxxxxxxxxxxxx
> This is a new one for me. I have a shared database with linked tables.
> Both
> databases reside on our share drive. The path for the linked file is > set
> to
> S: drive, which is the default for most employees. Our HR department,
> however, has the S: drive mapped to their own share. When the HR folks
> try
> to use this shared database, they cannot access the linked tables.
>
> In the past, I have worked around this by using UNC conventions for the
> linked tables (\\server\path\filename). This time, however, when I > made
> that
> change, the users started getting an error message "The Microsoft Jet
> engine
> cannot open the file. It is already opened exclusively by another > user,
> or
> you need permission to view its data."
>
> I would appreciate any help if someone has encountered a similar
> situation.

.

Relevant Pages

  • Re: log in box
    ... Microsoft MVP - FrontPage ... in from front page directly but I get an error message that says I don't ... have permission yet I don't get any where to log in. ... >> FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • Outlook error messages
    ... This is the Error Message: ... >exist, you may not have permission to open it, or it may ... >Properties to check your permissions for the folder. ... >error occurred in the shortcuts file. ...
    (microsoft.public.outlook)
  • cant set scheduled tasks
    ... get an error message - access denied - do not have permission to perform ... "This written advice was not intended or written to be used, ... be used by any taxpayer, for the purpose of avoiding penalties that may be ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Issue with path / permissions for linked table
    ... The UNC path is generally the best solution. ... You can get that error message if the user does not have adequate permissions on the share. ... If they don't have permission to create a file, Access can't create the LDB, and you get that message. ... databases reside on our share drive. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access Connection problem in aspx page
    ... Error message likes this: ... Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet ... database engine cannot open the file 'C:\db\Northwoods.mdb'. ... the problem seems about the permission. ...
    (microsoft.public.inetserver.asp.db)