Converting to SQL Server- any 2003 advantages?

[Diarmuid]

Hi
I have two clients who are on Access 2000 now and are converting to SQL
server in the coming months. Both have Office 2000 professional. We're
planning to keep the Access front end.
Is there any features in Access 2003 that be worth upgrading for in this
scenario? I have MSDN, so I can distribute the 2003 runtime if necessary.
(Though of course it makes it easier onsite if someone has the full
version). Anyway, is there any additional ADP features in 2003? I've search
online, but I can't find anything specific for Access/SQL Server.
Thanks
Diarmuid

 

[Sylvain Lafontaine]

Same features, less bugs. The runtime should be fine.

S. L.

 

[Alex Dybenko]

Hi Diarmuid,
you can also consider to leave MDB(MDE) and have linked tables to SQL
server. Of course - you have to redesign a lot, but not so much as for ADP.

Anyway - upsizing to SQL server will bring you better performance and
reliability

--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

 

[Alex Dybenko]

Here something you can read on this subject:
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/sqlbackend.asp

--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

 

[Diarmuid]

Thanks!

Here something you can read on this subject:
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/sqlbackend.asp

--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com