Report on data outside of current database

[ideafixer]

I am new to using data outside of my current database. Since reports cannot be bound to a recordset, what is the best way to report on SQL/Server, Oracle or other datasources outside of setting up a link. Let's say through the ADO.

 

[randysmid]

Hi,
It appears as though you never got a response to your request. Are you still interested in a solution? I am asking because this appears to be possible, and I am preparing some info on it right now.
HTH,
Randy Smith
California Teachers Association

 

[ideafixer]

Well I did end up setting up an ADO connection then downloading that data to a Access table. That was my solution. Seems to be working out pretty good.

 

[randysmid]

Hi,
I suppose you know that you didn't need to download the data, but instead just link to it. Of course, if the outside data changes often, you will need to download that data periodically. HTH,
Randy Smith
California Teachers Association

 

[ideafixer]

I am aware linking is possible. The datasource we are using on SQL/Server can change often. Using ADO seemed to be the best methode for handling the databases changing location. Plus, I was under the impression an ADO connection is faster? What do you think?

 

[randysmid]

Hi,
I have used both methods to connect to a database, and never really saw much difference. I have not done any formal kind of speed test, so I cannot tell for sure which is fastest. Personally, I prefer to let Access do most of the work by having the links pre-created inside Tables.
HTH,
Randy Smith
California Teachers Association