I have a 2016 password protected Access database that contains a query that i need to pull the results from into Excel i have set the database encryption to legacy the issue I am having is that the query uses several functions that are defined in the Access database. when rs.open "select * from qrySalesExport", con runs i get an error stating that one of the named functions in Access is undefined. the query runs perfect inside of Access.
any help is appreciatied!
any help is appreciatied!