XP Problems Access 97 Database Functions

J

John Pollitt

We are having problems with Access 97 queries after we the
have upgraded OS Win95/Win 2000 machines to XP.

Queries which use the IIF or Left or Len functions
generate the following type of error (and the query will
not run):

RunTime Error 3075

Function isn't available in expressions query session
'IIf(Len(Format[Billing_Date]="ww"))=1,'0',Format
([Billing_Date],"ww" etc

The queries run fine on machines with OS 2000 or 98/95.

Any help would be greatly appreciated as we are upgrading
all our machines to XP.

Many Thanks
JOHN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Intrinsic Functions Not Working 10
Access 97 executables and other versions of Access 13
Access 2000 with Windows XP and W7 -- problems 0
Office 2003 upgrade conflicting with Access 97 database 3
Problems with Access database since conversion to Access 2007 and Vista 2
error 3075: functions such as CHR$ not working on Vista 1
MDE problem in Access 2007 12
AUTOEXEX Macro - Check OS or Access Version BEFORE Enable MACRO Security 0

Top