Best cohabitation Access 2007 ans SQL Server 2008

Access project 2007 is the best solution front-end sql server 2008 for data
management (not administration)?
SQL Native Client in OLE DB mode save throutput net and data in lowest and
discontinuous vpn?
I still use Access for old DB2 via ODBC and I need porting old db in new sql
server 2008 by use Access 2007 adp.
New db is not web oriented, it is designed for small-medium size (20 users).
Is this goal a "blood bath"?
I need your opinion for my sleepless night.
Thank you.
Daniele

Hi,ADP is not recommended way to build frontend for SQL server, better use

Hi,
ADP is not recommended way to build frontend for SQL server, better use MDB
with linked tables

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

Alex Dybenko wrote:In my exp.

In my exp. I verified that were many many many traffic on the net with other
data provider.
i.e: join are "linked" on the client dropdown millions and millions record
before.
Why do you prefer mdb (or pass-through like - we actually use query pt)?
Thanks
Daniele

Hi,of course - you do not need to link tables on the client, all

Hi,
of course - you do not need to link tables on the client, all ready-only
queries should be pass-through, run on server and return only required
number of records

And linked tables used to enter new/edit data, you have to open such edit
forms also filtered, user should not have possibility to open form with
table without filter

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

I bind view byhttp://support.microsoft.com/?

I bind view by
http://support.microsoft.com/?scid=kb%3Ben-us%3B281998&x=14&y=11

Many query are editable.

Thanks.

Daniele