473,890 Members | 1,360 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problems running an Access dbase on Parallel Desktop for Mac

44 New Member
Hello, I have developed and tested an Access database that I now wish to distribute. It works well on all computers tested, including an Apple Mac running Parallels Desktop, but with one exception. When using the Mac, on the command to open an existing PDF it fails to deliver, with no error message. The VBA I am using to do this is as follows:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_DblClick(Cancel As Integer)
  2. On Error GoTo 10
  3. Dim strFile As String
  4. Dim lngErr As Long  
  5. strFile = "C:\Wheelbase\Invoices\" & Me!Account & "-" & Me![Inv No] & ".pdf" 
  6. lngErr = ShellExecute(0, "OPEN", strFile, "", "", 0) 
  7. 10
  8. End Sub

Expand|Select|Wrap|Line Numbers
  1. Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" ( _
  2. ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, _
  3. ByVal lpParameters As String, ByVal lpDirectory As String, ByVal ShowCmd As Long) As Long
It works fine with Windows. Is there a compatibility problem with 'Parallels' on the Mac?

Jul 18 '12 #1
12 26483
5,501 Recognized Expert Moderator Expert
Which version of Access are you running on the Mac?
Which version of the emulation OS are you running on the Mac?
Jul 18 '12 #2
Nick Cooper
44 New Member
The Mac is running Access 2007 and it is using Version 7 of the Parallels Desktop OS.
Aug 5 '12 #3
5,501 Recognized Expert Moderator Expert
Sorry to take so long to get back to you.
The family was on vacation and I'm only just now really getting things back on track... work tomorrow and more things to get back in order there :)


Talked with a Mac friend... he mentions that sometimes the file associations can be bodged in Parrallels and is the very first thing to check... easy enough:
Can you open other pdf files directly in Acrobat on the Mac in question?

If so then try modifing line 6 as I believe that you are telling the application to hide the window upon open:
Expand|Select|Wrap|Line Numbers
  1. ShellExecute(0, "OPEN", strFile, "", "", 3)
( http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx )

If you can not open pdfs directly then you'll need to resolve that issue first and that is well outside of this thread; there are however some really good Mac forums that should help in this case.

Aug 5 '12 #4
Nick Cooper
44 New Member
Thanks for that and no probs about the delay. Yes, PDFs do open from Windows Explorer, but not when accessed via the ShellExecute command from within Access. Sadly that is still the case when I replace the 0 by a 3 in the 6th line of code, as suggested. I confess to not being an expert on the coding, having pasted it in from a previous interchange with 'Bytes', but it has worked flawlessly for 2 years now, on a number of XP and Windows7 OS computers. Any other thoughts please?
Aug 6 '12 #5
5,501 Recognized Expert Moderator Expert
Haven't missed you... just back from vacation and lots to catch up on.
I'll ask my Mac friends about this... may take a tad to get an answer back as they live way across the country.
Aug 6 '12 #6
5,501 Recognized Expert Moderator Expert
Well that was fast....
My buddy says that you should start at the beginning of this thread to get a background on the issue, and of note is post #130 on page 7... I think he deals with this alot:
SO, it appears that this may be a VM issue which is so beyond what I can help you with ( honestly... I don't know enough about the parallels environment to be much if any help if the issue lies there-within )
Aug 6 '12 #7
Nick Cooper
44 New Member
Well I guess that makes two of us! Post #123 in your link seems to offer a solution which I might try, but you can't really distribute a database along with some complicated instructions to make it work properly on some machines. It looks like I will have to reduce the functionality to ensure compatibility across the board. Shame.
Thanks for your guidance!
Aug 7 '12 #8
Nick Cooper
44 New Member
Maybe there is another way I can get round this problem. The reason for the above code was to ensure that a PDF could be created without having to bother about the Adobe version number being updated. Originally I used the following code, but it was messy as it would require the user to update the path every time the version changed:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_DblClick(Cancel As Integer)
  2. Dim strProg As String
  3. Dim strFile As String
  4. strProg = "C:\Program Files (x86)\Adobe\Reader 10.0\Reader\AcroRd32.exe"
  5. strFile = "C:\Wheelbase\Invoices\" & Me!Account & "-" & Me![Inv No] & ".pdf"
  6. Call Shell(strProg & " " & strFile, vbMaximizedFocus)
  7. End Sub
Is it possible to use a wildcard in the \Reader 10.0\ directory so it would be independent of whatever version number was running? I have tried using stars '*' but to no avail.
Fingers crossed!
Aug 8 '12 #9
5,501 Recognized Expert Moderator Expert
I don't think that you can use the wild-card.

As far as I know, from the code you've posted, you will have to determine which version is installed and then build the string.

This will be a tad out of my normal as once again I don't know how your VM works.

I would suggest going back to the forum in the link I posted in #7 and posting the question there too... someone with more Mac/Paralles may very well have this solved on their site.

Aug 8 '12 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Michael Schmitt | last post by:
Hello. What is the usual way for running functions in parallel on a multiple-processor machine. Actually I want to run a single computationally expensive function with different parameter sets. Running the functions in different threads doesn't seem to work, because of the global interpreter lock. Would it help to fork processes, which run the single function with a given parameter set? Is there any simple way, how this forked worker...
by: Wayne Aprato | last post by:
Can anyone shed any light on the following problem which has shown itself in a couple of my Access 97 databases. When I ask Access to open a form that is based on a query, it will randomly fall over. The query itself is based on a form which has several criteria fields, some of which are combo boxes. The undesired behaviour seems to be related to the combo boxes. When a value is chosen from one or more of them and I click the button...
by: Jim Pettway | last post by:
I am trying to run MS Access 97 on Windows ME and it continuously crashes (will not read Access data and then Windows locks up). The program runs fine on Windows 95 and Windows XP. Somewhere I read that Windows ME had problems with Access 97. Has anyone had any experience with this setup? Please give me some help with this situation. Jim Pettway
by: Rob | last post by:
I am an Access developer and have done many Access databases in the standard Front-end on the workstations, backend on the server (over a LAN) but have never worked with Access over Citrix, though that situation is coming up for me shortly. Question: When you run the front-end on the Server, does Citrix clone the front end application database file for each user that connects or do they all connect to physically the same front-end...
by: Jesper | last post by:
Hi, I am experiencing some problems running a .net exe placed on a network drive. File IO operations and access to reg db results in access denied exceptions. If I run the same program from a location locally on my machine I do not have any problems... Anyone who knows why? rgds Jesper.
by: louise raisbeck | last post by:
Hi I know I may be repeating some past questions but i wasnt sure if i added on to these if they would appear in the 'new list'! I have IIS 5 installed, IE 6 and visual studio .net 2003. When i create an aspx page under iis, when i try to run it via localhost i get the 'Open/Save' screen, i.e. it is not running the code but just ends up opening it in visual studio. I went to the downloads (thinking i may not have installed the SDK for .net) but...
by: loreille | last post by:
To insert a record in a Ms Access database and be able to retrieve the newly created ID (autonumber) I used the code below (code 1). Now, the problem is that this is not very secure and that, if for example an insertion contains a ' or a " this code fails. It is much better to work with @parameters. So could someone change my code to make it work with @parameters and
by: yxq | last post by:
Hello, The XP Desktop clean wizard can get the last access time of desktop shortcut, i found that the info come from "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\UserAssist\{75048700-EF1F-11D0-9888-006097DEACF9}\Count" The valuename and value are encrypted using ROT13, the function below can decrypt them *************************************************************
by: RocketBot | last post by:
Hi I am having problems running a site localy using the IIS server. Running pages normally is fine, but when I use a master page the VB Controls do not work. For example a button on the page will not clickable, instead when you click on the button the button is selected and can be moved around or deleted. Any Ideas?
by: chiefsitebuilder | last post by:
I have a question about saving an MS Access program to CD and verifyng that the program works after being saved. Here is my situation, I have a person who developed an application for me using MS Access 2003 and the person will be transferring ownership to me. The developer will be giving me a CD with Access DBase source code on it. How do I verify that he gives me everthing I need to run the application once the developer departs. ...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.