Re: Why I can not access remote database

From: Ray at <%=sLocation%> [MVP] (%=sLocation%)
Date: 02/13/04


Date: Fri, 13 Feb 2004 14:31:53 -0500

The .mdb file is on a different machine? How are you trying to access it?
Via a UNC path? Take a look at this page and make sure you didn't miss a
step somewhere.
http://www.aspfaq.com/show.asp?id=2168

Ray at work

"Loc" <anonymous@discussions.microsoft.com> wrote in message
news:1D663709-B9F2-48CA-84B5-496D66E20E96@microsoft.com...
> I have asp page needs to access remote database, I got error"The Microsoft
Jet database engine cannot open the file 'Unknown'. It is already opened
exclusively by another user, or you need permission to view its data. ".
> Could anyone show me the steps to configure permission?
> (I tried creating IUSER_DBMACHINE local account on the database box, give
this account full permission on the database folder, doesn't work)
>
> Thanks
>
> Loc



Relevant Pages

  • Re: Can It Be Done? - MDB Security
    ... Copying it doesn't prove anything. ... permission that allows the file to be written to will also allow it to be ... The other solution is to migrate the data to an SQL Database. ... possible to use the Access MDB file to create a "front-end" to the SQL ...
    (microsoft.public.windows.server.networking)
  • RE: Error 3734
    ... I'm not sure why this was posted to the "reports" news group however, ... first make sure that every user has permission to create and delete files in ... the folder containing the MDB file. ... This error message indicates that a user set the database in a mode ...
    (microsoft.public.access.reports)
  • Re: PROBLEM WITH MY CONNECTION DATABASE
    ... Is the path to the MDB file in the error message correct? ... The fact that you have permissions on the database does not mean that the ... web-server does unless you have disabled anonymous access. ... And I have full permission because i am administrator. ...
    (microsoft.public.inetserver.asp.db)
  • Why I can not access remote database
    ... I have asp page needs to access remote database, I got error"The Microsoft Jet database engine cannot open the file 'Unknown'. ... It is already opened exclusively by another user, or you need permission to view its data. ... (I tried creating IUSER_DBMACHINE local account on the database box, give this account full permission on the database folder, doesn't work) ...
    (microsoft.public.inetserver.asp.general)
  • Re: QRe: Legacy Access 2 VB 4 app, Word 11 merge on XP Pro SP2 client
    ... selecting "blank database" or some such. ... possible to set a simple password on a whole mdb file, ... case, make sure you have a backup of the .mdw file, then launch Access ... >I could not get the app to accept the changes to Notepad within the ...
    (microsoft.public.access.conversion)