Anyone ever used Access Projects? ....

[WhytheQ]

I'm used to Access MDB and all is well, nice and easy to use....but
Access Projects really seems user unfriendly. Any one got any ideas?
Should I stick with Projects, or go back to the nice comfortable Access
environment ?

Any help greatly appreciated
J

 

[Rico]

Hi J,

It depends on what the client needs really and of course, how well you adapt
to change. The Access Data Project is an excellent solution because it
gives you the speed of application development with the robust power of SQL
Server (which makes it very scalable). The ADP bypasses the Jet DB engine,
so if there is anything quirky with Jet, those issues disappear. The caveat
is that you have to learn TSQL, which is another excellent tool to have in
your arsenal.

Both approaches have their place really and alot depends on the customer.

Rick

 

[Van T. Dinh]

Some people do like ADPs .... but Microsoft currently recommends the use of
linked Tables, i.e. MDB format.

It comes down to your personal choice and whether you want to follow
Microsoft's recommendation ... ADP will still be supported in Access 2007
and that mean main-stram support till at least 2012 and limited support till
at least 2017 (I won't worry about any database, MDB or ADP, I developed if
I am still aound then <g>).

 

[aaron.kempf]

http://blogs.msdn.com/access/archive/2005/11/01/488022.aspx

We continue to believe that SQL Server makes a great store for Access
data and that building the UI either through linked tables or ADPs will
continue to work well.