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

  • From: "Jeremy Saunders" <jeremy@xxxxxxxxxxxxxxxxxxxx>
  • To: <thin@xxxxxxxxxxxxx>
  • 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:  <mailto:Ben.Pelzer@xxxxxxxxxxx> Ben.Pelzer@xxxxxxxxxxx
> To:  <mailto:thin@xxxxxxxxxxxxx> 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, " <mailto:thin-digest@xxxxxxxxxxxxx> 
> thin-digest@xxxxxxxxxxxxx"
> < <mailto:thin-digest@xxxxxxxxxxxxx> thin-digest@xxxxxxxxxxxxx> wrote:
> 
> >
> > ------------------------------------
> >thin Digest Tue, 07 Jan 2014 Volume: 12 Issue: 204
> >
> >In This Issue:
> > #1: From: Angela < <mailto:angela_smith9@xxxxxxxxxxx> 
> > angela_smith9@xxxxxxxxxxx>
> > Subject: [THIN] Microsoft Jet database engine error on Windows 2008
> >
> >----------------------------------------------------------------------
> >
> >Msg: #1 in digest
> >From: Angela < <mailto:angela_smith9@xxxxxxxxxxx> 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> //www.freelists.org/list/thin
> >************************************************
> 
> 
> 
> Met vriendelijke groet,
> 
> drs. Ben Pelzer
> Senior Consultant
> 
> E-mail:  <mailto:Ben.Pelzer@xxxxxxxxxxx> Ben.Pelzer@xxxxxxxxxxx
> 
> Amerikalaan 90 - 6199 AE Maastricht-Airport
> Tel: +31 43 850 7000
> Fax: +31 43 352 1718
> Internet:  <http://www.openline.nl> www.openline.nl
> 
> 
> ��+r�z�RJ��˛���m�n�+����ǭ
(‑��+U��*'��^�ǭ��ޖ�%�y!���
0~���+-����X���a�

Other related posts: