Access 2010 files (.accdb)

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
bfsultan
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

Access 2010 files (.accdb)

Post by bfsultan » 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__

Post Reply