Tony Septav
TSeptav at Uniserve.com
Wed Jan 9 10:47:39 CST 2013
Hey Gustav Thanks To be honest I never knew there was a ProgramData folder. Anyway I just create folder on the C: drive for installation of the program. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: January-09-13 3:26 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] ACCESS2003 Function is not Expression Hi Tony To relief your frustration, you just have to realize that your frontend is not a program; Access is the program, your frontend is data. The Program Files folders are not to be tampered with by non-admin users. Use the ProgramData folder. /gustav -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Tony Septav Sendt: 9. januar 2013 00:51 Til: 'Access Developers discussion and problem solving' Emne: [AccessD] ACCESS2003 Function is not Expression Thanks to all who have responded It is a simple Variable response in a field in the Query Grid eg - Something: left([Field],1) I have tried the same thing using many different tables. Each query when run generates the same error message on the client's machine (not mine). As mentioned I have his laptop so I can try different scenarios. As many of you have mentioned (myself included) I have seen this before, but thinking at the time I would never forget what caused the message I never wrote it down. I do not want any cheese with my "Whine", but Windows 7 security has caused me endless grief in my coding. The latest being, on my install I put the front end in a subfolder in the Program Files (or (x86) )folder, when the program tried to do a "repair and compact on exit" a message would appear telling me something like I did not have ADMIN rights to do this. So I had to change my install location for the front end. This is "mystery meat" and I either solve it or rewrite it to come at it from a different direction. Ask me if I am frustrated. Thanks Again -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com