Thank you for your thoughts on this situation. Currently my employee seems
to be firmly in place with using SQL 2005. With this in mind I am now trying
to determine which is best with the SQL connection, either accdb or adp. I
hear opinions supporting each way but I'm trying to determine what factual
evidence is the most swaying. I appreciate any thoughts on this.


"GBA" wrote:

I seem to be in a minority in believing that the ever increasing power of the
PC, plus that LANs generally are not bandwidth constrained - means that the
requirement to move to sqlserver is pushed further and further away each year.

There seems to be an overwhelming fixed opinion that if any Access problem
exists it is viewed that the solution is to 'up size it' to sqlserver....
Which is to say the opinion is to move to sqlserver and not move away from
sqlserver as most presume growth.

There are several good & valid reasons to move to sqlserver - it is a very
solid product - - so at the same time there would need to be solid reasons to
move away from it. If your organization is running sqlserver routinely for
several other db apps then one would tend to think you should stay with it.

On the otherhand you kind of imply your company is downsizing in various
dimensions - and going strictly PC/LAN environment is certainly more frugal
than managing sqlserver. Fundamentally can Access do the job? that's kind
of yes/no...and then which is less/more painful? managing the exiting
environment vs the effort to downsize it off sqlserver....

Am not sure any generic advice can really assess your situation from a
forum...

"briank" wrote:

I have inherited an A2007 adb with a connection to SS2K5. I have recently
begun trying to follow the various VBA code compiled by four different
consultants which is a bit of a challenge in itself. Since my company's
needs have changed over the past months I feel that it would be cost
effective to simply create a new db from scratch. However, I am not sure of
the advantages of ADP or simply sticking with ACCDB. I would appreciate
feedback on this scenario. TY.