Hey guys I never thought it would happen but I'm stumped LOL. My problem is that I have a mapped drive H: to another system which has an ACCESS MDB file on it that I need to query. I've set up my ODBC ACCESS Driver and it works great if I use the SQL query analyser but when I try to use <CFQUERY> I get an error. So I go into CF ADMIN and look at the connection and if I click on browse next to the file path field all it shows is my local drives. It doesn't show my mapped drive H:. This company is running CF 4.0. Any ideas.
Thanks in advance