[AccessD] Error 3075 in app running on a Mac with Parallels

Jim Lawrence accessd at shaw.ca
Mon Jan 21 18:42:32 CST 2013


All I can say is, "Good Luck" ...computers are such finicky creatures.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, January 21, 2013 4:00 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 3075 in app running on a Mac with Parallels

I'll have him install in a clean parallels machine tomorrow - see if that
helps.

R

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, January 21, 2013 3:38 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 3075 in app running on a Mac with Parallels

He may not have removed the previous versions of Office via the "Add remove
programs" off the control panel and maybe a product like CCleaner might
assist cleaning up the registers. 

The older versions of Office leave all sort of pieces of itself, when a
newer version is installed and maybe a serious initial cleanup may help.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, January 21, 2013 3:16 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 3075 in app running on a Mac with Parallels

I originally sent him the run-time version and it had this problem.  So he
bought Access 2010 and Excel 2010 and installed them a la carte.  Same
problem.  

Rocky




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, January 21, 2013 2:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 3075 in app running on a Mac with Parallels

It does sound like a reference error. 

I have had that error when working with mixed Office versions.

If there is some Windows offset reference missing that may be the error.
Some references are positional. Is your client running Access, on Parallel,
in an installed version of Windows? Has the client run updates or mixing and
matching?   

Off the top, I would suspect your client has been mixing Office versions?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, January 21, 2013 12:51 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Error 3075 in app running on a Mac with Parallels

Dear List:
 
I have a user of my commercial app, distributed as mde compiled in 2003.
Runs fine under windows.  
 
This client is running on a Mac using parallels, and gets an error 3075 -
Function is not available in expressions in query expression 
 
'left(OrderNumber,7) = '2013501'
 
where '2013501' is an order number and its a filter that's being created.  
 
He's running Access 2010. 
 
Looks like a broken reference but, of course, it runs fine here on my 2010
test bed.
 
Any ideas?
 
MTIA
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
<http://www.e-z-mrp.com/>
Skype: rocky.smolin
 
--
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

--
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

-- 
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