ADP or MDB for Reports

[PNC]

Hi,

I'm trying to think of advantages of using an ADP over a MDB database for a reporting database... currently the database has a form (with some VBA codes in it) for reports selection and pass-through queries that query the SQL Server production database.

Right now, I can change the pass-through queries on the fly and they are just as fast as stored procedures, and I do not have dbo rights on the SQL Server database. The number of users should not matter because there is no table in the access database.

Any ideas?

Thanks.

 

[jgoodman00]

I would probably be tempted to go with the ADP.

If you change a query (view or sp) in an adp, you are updating the server object, & thus any number of users will get the new data returned. However, if you use linked tables (mdb), then the queries are stored locally & subsequently if you update a query object, only your copy will have that new object.

Whilst it might not matter at the moment, you should also reduce network traffic by using SP's, as only the required data is sent across the network, rather than the whole recordset.

James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com