problem with libraries in MS Access XP

gillx · Post by **gillx** » Fri Mar 13, 2009 12:37 pm

Hello. Firstly sorry for my bad English, I'm just studying that. So, I have problem with program MS Access XP. I found on this website, that this version of Access is only one which is running under the Wine correctly, so I downloaded it. Installation was OK. When I want to create blank database, there is this error: "Microsoft Access can't load the dynamic-link library mswstr.dll. You need to resolve the failure and start Access again." When I wan't to open existing database, there is the same error but with msjet40.dll library. However, these libraries are in System 32 directory. I tried to download these libraries from internet and replace old one by libraries I've downloaded. I also tried to get these libraries to winecfg, but problem is still hear. Of course, I'm running Wine as Windows XP and I have this version: 1.1.16. Could you help me please?

Thanks

austin987 · Post by **austin987** » Fri Mar 13, 2009 12:42 pm

On Fri, Mar 13, 2009 at 12:37 PM, gillx <[email protected]> wrote:

Hello. Firstly sorry for my bad English, I'm just studying that. So, I have problem with program MS Access XP. I found on this website, that this version of Access is only one which is running under the Wine correctly, so I downloaded it. Installation was OK. When I want to create blank database, there is this error: "Microsoft Access can't load the dynamic-link library mswstr.dll. You need to resolve the failure and start Access again." When I wan't to open existing database, there is the same error but with msjet40.dll library. However, these libraries are in System 32 directory. I tried to download these libraries from internet and replace old one by libraries I've downloaded. I also tried to get these libraries to winecfg, but problem is still hear. Of course, I'm running Wine as Windows XP and I have this version: 1.1.16. Could you help me please? [Question] Â Thanks

$ wget kegel.com/wine/winetricks
$ sh winetricks jet40

--
-Austin

gillx · Post by **gillx** » Fri Mar 13, 2009 1:19 pm

Thanks for advice, the problem is solved. But there is another. If I want to open existing database, there is this error: Microsoft Access cannot open this file. This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location

austin987 · Post by **austin987** » Fri Mar 13, 2009 1:27 pm

On Fri, Mar 13, 2009 at 1:19 PM, gillx <[email protected]> wrote:

Thanks for advice, the problem is solved. But there is another. If I want to open existing database, there is this error: Microsoft Access cannot open this file. This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location

Hmm. I don't know on that one. Terminal output?

--
-Austin

FreeMinded · Post by **FreeMinded** » Fri Jan 08, 2010 6:11 am

Hi

I just ran into this problem as well. The MS Access Runtime tells me:
"This file is located outside your intranetor on an untrusted site. <application name> will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location."

The file is in the regular wine location. The Runtime is started as follows: env WINEPREFIX="/home/user/.wine" wine "C:\Programme\Microsoft Access Runtime\Office10\runaccess.exe" /excl /runtime /profile "<application name>" /wrkgrp "C:\Programme\<application name>\system.mdw" "C:\Programme\<application name>\Program\<application name>.mde"

Has anyone found a solution to that? Any help is appreciated.

Post by **dimesio** » Fri Jan 08, 2010 10:40 am

FreeMinded wrote:Hi

I just ran into this problem as well. The MS Access Runtime tells me:
"This file is located outside your intranetor on an untrusted site. <application name> will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location."

The file is in the regular wine location. The Runtime is started as follows: env WINEPREFIX="/home/user/.wine" wine "C:\Programme\Microsoft Access Runtime\Office10\runaccess.exe" /excl /runtime /profile "<application name>" /wrkgrp "C:\Programme\<application name>\system.mdw" "C:\Programme\<application name>\Program\<application name>.mde"

Has anyone found a solution to that? Any help is appreciated.

Terminal output? Also, what version of Wine?

Razorwings18 · Post by **Razorwings18** » Sat Jan 09, 2010 2:59 am

Just stating the obvious, but ¿does the user have rwx permission on all files involved?

I once had a problem of the sort -on a different app- for having copied data files using the root account into my user's account, forgot to change permissions, and then run wine from said user.

FreeMinded · Post by **FreeMinded** » Sat Jan 09, 2010 7:19 am

Thanks for your fast response!

The programm was installed as user and it's run as user. The files seem to have the right permissions. As far as I can see. Group has read only but group is same as user. So I guess that should not be the issue.

The konsole output is no more than: fixme:font:SetMapperFlags (0x3e0, 0x00000001): stub - harmless

Version: wine-1.0.1 (from official ubuntu repositories)

Any other ideas?

Post by **dimesio** » Sat Jan 09, 2010 11:04 am

FreeMinded wrote: Version: wine-1.0.1 (from official ubuntu repositories)

That version is over a year old. Upgrade to the latest development release, currently 1.1.36.

paloi · Post by **paloi** » Sun Jul 18, 2010 7:39 pm

gillx wrote:Thanks for advice, the problem is solved. But there is another. If I want to open existing database, there is this error: Microsoft Access cannot open this file. This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location

Following this forum I solved the same problem of the jet4 dll, but then I hit the same: "This file is located outside your intranet or on an untrusted site. <application name> will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location."
... which I think I solved installing last Internet explorer via winetricks following same approach as for jet 4.
(Note that I manage to do it in CrossOver8, but I guess is the same for Wine.)

The idea from my solution came from reading this post http://chir.ag/tech/?23 and some other suggesting to add new trusted zones via Internet Explorer, which I did not need to do, as after installing Explorer, it was already able to open the files.

I admit the solution is a bit dirty, because running explorer Inside Linux is like leaving home every morning with the backpack full of stones, but it is also not very clean running Office inside Linux. I guess we do not have other option, as Open Office is very good for Word processing and spread-sheet but still not able to deal with MDB access files.