Ok, I’m having a little problem trying to find the best solution to get a BO query into Access. In a related thread we discussed my problems with the"exporting to RDBMS option" here, but that thread took a turn as to why we want to take the data to Access in the first place. Now, I am exploring the defining a personal connection option, although hestitant to provide this as a solution, I want to test it on my end and I am having problems defining the personal connection. I am trying to do it through Designer / Tools / Connections, I go to add a personal connection, define as ODBC, give it a name and engine (MS Access 97 or 2000), but then I am a little confused about the password/username and data source. I define secured connections all the time but this personal connection has me confused. I never use Access but I would like to be able to successfully test this option. What would I use for a password and username and what is the datasource (should this be the Access file or DB name; if so, how does it initially get created). Maybe I am overlooking the obvious here, but I am stumped. 
jswoboda 
(BOB member since 2002-06-20)