Best cohabitation Access 2007 ans SQL Server 2008

[OneEDP]

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

 

[Alex Dybenko]

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

 

[OneEDP]

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

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

 

[Alex Dybenko]

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

 

[OneEDP]

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

I bind view by
http://support.microsoft.com/?scid=kb;en-us;281998&x=14&y=11

Many query are editable.

Thanks.

Daniele