Will Access 2003 support SQL 2005 to create project forms

[Guest]

We use Access 2003 as front end to SQL2000 (28 users).We intend to migrate to
SQL2005 early next year and find our completed Access 2003 projects although
work ok with SQL2005 CTP we can not make changes to projects because Access
2003 does not support SQL 2005.Is there a way to convert Access adp to VB
without re creating in Visual basic

 

[Albert D.Kallal]

We use Access 2003 as front end to SQL2000 (28 users).We intend to migrate
to
SQL2005 early next year and find our completed Access 2003 projects
although
work ok with SQL2005 CTP we can not make changes to projects because
Access
2003 does not support SQL 2005.Is there a way to convert Access adp to VB
without re creating in Visual basic

I assume you are using a access project. I as a matter of course prefer
using a mdb with linked tables. The reason for this is then you can use any
odbc database, and yes, you can even use sql2005. mdb applications with
linked tables work very well with sql server. So, if you had used a mdb, and
not ADP project, then this problem would not be a issue. However, I had
assumed that you can put sql2005 in compatibility mode. So, I would check
that first.

And, if you are converting, then likely the best approach would be to
convert to a mdb, as then you can keep the same designs etc. You could
re-write the application in VB, but then you don't have things like
sub-reports, multi-column combo boxes, and you also don't have the great
report writer that ms-access has.


Anyway, I would check for the compatibility settings for the sql server, as
that should get your ADP projects working.