Access 2000, 2007 and SQL 2000 and 2005 questions?

[jjjax0330]

We are currently running Acsess 2000 and are looking to go to 2007 when it comes out and looking for a little help as to what path to take. Most of our development is done using Access as our frontend and sql 2000 as the backend. We use mostly .adp's and also use the developer edition of office so that we just install the Access runtime on user's computers. So here are some quesitons.

Are .adp's going to be supported in 2007? I have the beta version and it looks like they do open but do not see a way to create a new one and it from the little I found on Microsoft's site, they suggest not using them and more.

If we do have to use .mdb's, are they a little better in 2007 in that they will allow us to make table, view, sp design changes or would be still need to do all that in sql and use odbc links to sql? Or is there a better way?

Is there going to be a developer edition of Access 2007?

I tried opening an existing Access 2000 .adp and changed connection to be a sql 2005 database but does not seem to be compatable? I can see all the tables and views ok but doesn't allow and design changes like with 2000. Also, the sp's all have a ;1 after the name don't open either? Is Access .adp's able to link to sql 2005 databases?

Not sure where to get this info so just looking to get a little help. Thanks, Joe

 

[DanJR]

some remarks about adp project support for access 2007 is mentioned in this blog. It seems that MS recommend linked tables instead(??)

In terms of a developers edition, then i think you need Visual Studio Tools for Office (VSTO) for the license to ship a run-time license. This seems to be true for Access 2003 in VSTO 2005.

however, i know little about 2007.

cheers,
dan.