I use an ODBC connection to connect my Access database to the "Data Warehouse" at my university (this database was created by someone else years ago and uses Oracle 11g). I just updated to Windows 7 (64-bit) and moved to Access 2010 (though I still have 2007 on my computer). I created a 32-bit ODBC connection (which works fine) but I cannot figure out how to change where my macros go to "look" for the ODBC connection so that I can refresh my report.
Sorry that I don't know the proper lingo - but I need help! My Dean needs this report in 11 minutes
Thanks for reading!
Holly