About adp file?

[marks2007]

Hi,

How are you?

I confuse with mdb and adp file now.I am not sure when I should to use ADP format file and if ADP file only support ADO connection and not support DAO connection.


Thanks for help

Mark

 

[pbaldy]

An ADP will only work with SQL Server. MS does not seem to be pushing it anymore, and in fact seems to be moving away. While the format has its proponents, the consensus appears to be using an MDB with SQL Server instead.

 

[marks2007]

Hi Paul

I have a question.I use a mdb file and use ADO to connect SQL Server.

I get a error when I bind report recordset to ADO recordset.

It said 'the feature is not avaiable in MDB'.what this mean?Do I have to convert it from MDB to ADP format.

Thanks for help

Mark

 

[pbaldy]

I thought I remembered a thread about this recently, and apparently it was yours. Did you see Roy's answer there?

 

[Pat Hartman]

When you use an .mdb, you use linked tables and bound forms. Forms and reports are generally bound to queries.

If you find you need performance that you cannot get with standard Access queries, you can link to views.

The Recordset.Clone for Forms and Reports is DAO so that may be what is causing the problem.