Access 2010 files (.accdb)
Posted: Fri Jun 14, 2013 8:54 am
I am trying to create a report using an Access query that uses a user defined function. When I select the query in R&R I get a message "DB access:[Microsoft][ODBC Microsoft Access Driver] Undefined function ^Mbr_ID^ in expression"____I am using 32 bit Access on a 64 bit windows machine. I have tried to reload the drivers and have tried to add an OCDB entry using the 32 bit ODBC (odbcad32.exe). All with no success.____As a temporary work around, have copied the query results to a new table and R&R is fine with that, but I would prefer to use the query directly. Any suggestions would go a long way to saving my sanity__