Connecting BO to an Access Database

[aarondewberry]

All. I am trying to use business objects to report on my access database. I am creating a new report via the report wizard and selecting the free hand sql option. I have established a connection to my database and a tested the connection which says it is responding. However I am a little stumped as to what sql i have to write in order to report on my database.
Is this the right way of doing it?
My table in my access database which i want to connect to is called 'accounts setup'.
Any help would be appreciated.

Many thanks

 

[skrandel]

Free hand SQL is almost never the right thing to do. You should be using Designer to build a universe and then using that universe to build queries.

Free-hand SQL requires that you know all the syntax specific to your database. That defeats the purpose of using Business Objects.

Steve Krandel
Symantec