Access 2007 and ADP projects

[Eva]

Hi all

I´m an Access 2000 ADP user, and I´m finding some troubles when looking for
this format (existence or not) in Access 2007. I´ve found this link:

http://technet2.microsoft.com/Offic...ba1c-446a-8ff2-221769a58ba51033.mspx?mfr=true

But nothing is as clear as I need. Could you help me about this?

TIA

Eva Etxebeste

 

[aaron.kempf]

you can save any accdb to adp format.. is that what I understand?

 

[Sylvain Lafontaine]

Access 2007 offers full support for the old format ADP: you will be able to
open and edit them from A2007 but contrary to the MDB file format, there is
no new format for the ADP format: the same old ADP format is used in all
cases under A2007 and probably that they are also binary compatible with
Access 2002/3.

The link that you have mentionned make a direct mention of this:
« Access 2007 and SQL Server
.... Office Access 2007 offers two ways to connect to SQL Server data:
linking to SQL Server and Access Data Projects (ADPs). »

However, as I did not have the pleasure of installing the RTM version of
Access 2007 yet, I cannot tell you for sure that there won't be any
compatibility problems or other kinds of trouble.

 

[Eva]

Thanks, Sylvain

Access 2007 offers full support for the old format ADP: you will be able
to open and edit them from A2007 but contrary to the MDB file format,
there is no new format for the ADP format: the same old ADP format is used
in all cases under A2007 and probably that they are also binary compatible
with Access 2002/3.

The link that you have mentionned make a direct mention of this:
« Access 2007 and SQL Server
... Office Access 2007 offers two ways to connect to SQL Server data:
linking to SQL Server and Access Data Projects (ADPs). »

However, as I did not have the pleasure of installing the RTM version of
Access 2007 yet, I cannot tell you for sure that there won't be any
compatibility problems or other kinds of trouble.