[THIN] Re: Microsoft Jet database engine error on Windows 2008

  • From: Angela <angela_smith9@xxxxxxxxxxx>
  • To: "thin@xxxxxxxxxxxxx" <thin@xxxxxxxxxxxxx>
  • Date: Mon, 13 Jan 2014 22:11:47 +1100

Hi Jeremy

Thanks for the email..  Will try Process Monitor to see if it finds anything..

1) I tried to run Access as a local Admin, same issue which rules out a temp 
file ACL issue
2) Permissions are OK.  Users can already launch the DB from the share using 
the old Windows 2003 Citrix farm (32 bit).  The DB only fails from Windows 2008 
Citrix farm (64 bit).  The DB is launched from a mapped drive.
3) ODBC settings are identical to the old Citrix server. 32 bit ODBC app was 
used

I copied the DB to the Citrix server but I couldn't even launch the DB.  I get 
a different error.  DB only seems to launch from the mapped network drive..

Thanks
Ang

From: jeremy@xxxxxxxxxxxxxxxxxxxx
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Microsoft Jet database engine error on Windows 2008
Date: Thu, 9 Jan 2014 11:04:59 +0800

Hi Ang, As Mark Russinovich will tell you, “When in doubt, run Process 
Monitor!” There are probably a couple of things here to look for.1)      Access 
may be having difficulty creating the temp files for the local user when they 
open the front end.2)      Permissions on the share it’s on may need further 
attributes set for 2008 R2. I have seen this before. Are you using a DFS 
location? Is it a mapped drive?3)      I doubt ODBC is an issue, but you never 
know. Access can throw up some strange errors at times.

It doesn’t sound like you’ve isolated the issue enough yet. The suggestion from 
Magnus to try copying it locally into the users profile, giving them full 
control,  will at least allow you to isolate the issue to the file share, 
removing local temp file and ODBC issues. If it still doesn’t work from there, 
at least you can exclude the file share as an issue for the time being. 
Cheers,Jeremy From: thin-bounce@xxxxxxxxxxxxx 
[mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Angela
Sent: Wednesday, 8 January 2014 11:52 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Microsoft Jet database engine error on Windows 2008 Hi Ben

Yes I'm using the 32 bit ODBC application.  The App wont allow the user to 
login if the ODBC connection is wrong.  This is definitely OK.  Thanks for the 
email though..

Ang> From: Ben.Pelzer@xxxxxxxxxxx
> To: thin@xxxxxxxxxxxxx
> Date: Tue, 7 Jan 2014 12:10:18 +0100
> Subject: [THIN] Re: Microsoft Jet database engine error on Windows 2008
> 
> Hi Angela,
> 
> You mentioned ODBC connections
> Have you checked that your application is using the 32bit ones?
> On a 64bit system you have 2 ODBC connection ²possibilities²: 32bit and
> 64bit
> 
> 64bit:
> c:\Windows\System32\odbcad32.exe (!)
> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
> 
> 32bit:
> c:\Windows\Syswow64\odbcad32.exe (!)
> HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC
> 
> The odbcad32.exe really are switched, so watch out for that!
> 
> Cheers,
> Ben
> 
> On 07-01-2014 11:53, "thin-digest@xxxxxxxxxxxxx"
> <thin-digest@xxxxxxxxxxxxx> wrote:
> 
> >
> > ------------------------------------
> >thin Digest Tue, 07 Jan 2014 Volume: 12 Issue: 204
> >
> >In This Issue:
> > #1: From: Angela <angela_smith9@xxxxxxxxxxx>
> > Subject: [THIN] Microsoft Jet database engine error on Windows 2008
> >
> >----------------------------------------------------------------------
> >
> >Msg: #1 in digest
> >From: Angela <angela_smith9@xxxxxxxxxxx>
> >Subject: [THIN] Microsoft Jet database engine error on Windows 2008
> >Date: Tue, 7 Jan 2014 21:53:36 +1100
> >
> >Hi
> >
> >
> >I have a internally built MS Access based front end application that
> >hooks into a
> >SQL Server backend. The client works fine from Windows 2003 32 bit
> >Citrix system. Im trying to get the App to run from a 64 bit Windows 2008
> >R2 Citrix Server. I can login to the DB but get the following error:
> >
> >
> >
> >Microsoft Office Access
> >
> >The Microsoft Jet database engine cannot open the file xxxxxx. It is
> >already opened exclusively by another user, or you need permission to
> >view its
> >data.
> >
> >
> >
> >Detailed information:
> >
> >1. The database front end is based on Microsoft Access 2003. MS Access
> >2003 is currently running on a Windows 2003
> >32 bit Citrix server and it works fine which rules out any folder ACL
> >issue
> >
> >2. The database back-end is running on
> >Windows 2008 SQL Server
> >
> >3. The MDB file resides on a central network location
> >
> >4. The only thing required in the past to get the Application to work is
> >to
> >create a ODBC SQL connection and install MS Access 2003 on Citrix Server
> >
> >5. User access is fine as the Application works on the old 32 bit Citrix
> >system
> >
> >6. IIS is not installed nor is it needed
> >
> >7. Not a locking issue as I have up to 20 users accessing the DB from the
> >old
> >Citrix system at any one time. Application only fails on Windows 2008 64
> >bit system
> >
> >
> >
> >The new OS system is Windows 2008 R2 64 bit but the version of MS Access
> >2003
> >installed in 32 bit. Has anyone seen a similar issues?
> >
> >Thanks
> >Ang
> >
> >
> >------------------------------
> >
> >End of thin Digest V12 #204
> >***************************
> >************************************************
> >For Archives, RSS, to Unsubscribe, Subscribe or
> >set Digest or Vacation mode use the below link:
> >//www.freelists.org/list/thin
> >************************************************
> 
> 
> 
> Met vriendelijke groet,
> 
> drs. Ben Pelzer
> Senior Consultant
> 
> E-mail: Ben.Pelzer@xxxxxxxxxxx
> 
> Amerikalaan 90 - 6199 AE Maastricht-Airport
> Tel: +31 43 850 7000
> Fax: +31 43 352 1718
> Internet: www.openline.nl
> 
> 
> ��+r�z�RJ��˛���m�n�+����ǭ(‑��+U��*'��^�ǭ��ޖ�%�y!���0~���+-����X���a�        
>                                   

Other related posts: