[AccessD] Microsoft Jet Database Engine could not open the file-Error

Doug Murphy dw-murphy at cox.net
Fri Jun 4 17:52:27 CDT 2004


Thanks Jim,

I'll check security again.  We checked security and read only
properties, but that was me talking to the client via phone.  I may need
to go up and do it myself.

Doug






-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Friday, June 04, 2004 3:25 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Microsoft Jet Database Engine could not open the
file-Error 


Doug,

  First, check security.  All users need full read/write/delete priv for
the directory where the MDB/MDE resides.  This allows the .LDB file to
be created/deleted properly.  Without this file, Access/JET cannot place
locks and will open a database exclusive regardless of settings.

 Second, make sure the database attribute is not set to read only (right
click in explorer and click properties).

 Third, make sure someone is not really opening it exclusive.

  I think you'll find it's the first one.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Doug Murphy
Sent: Friday, June 04, 2004 5:54 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Microsoft Jet Database Engine could not open the file
-Error


Hi Folks,

I think I have a versioning problem here but would like to get others
inputs before spending a lot of time going down the wrong path and/or
driving the 50 miles to visit the client site.  I have a client with a
small peer to peer network.  We have an Access 2000 front end/back end
database on their system.  The machine with the back end on it is
running Windows XP. The other two machines with front ends on them are
running Windows 98.  There is also a front end on the XP machine.  The
database runs great on the XP machine.  The front end/backend were
linked using UNC paths on the XP machine.  The front end was then copied
over to the Win98 machines.  On opening the remote front ends there was
an error. In going through the various obvious debugging options I had
them try to open the back end directly from Access on the client
machine; we get an error message: "Microsoft Jet Database Engine could
not open the file "dbUNCPath\dbName.MDB"  It is already opened
exclusively by another user, or you need permission to view its data."
Access security is not set on the system and we looked at folder and
file permissions and that does not seem to be the cause.

I am wondering if this could be a jet issue.  Would different versions
of Jet on the machines cause this type of error?

Any inputs are greatly appreciated.

Doug



--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list