Hello all,

Been awhile since I've been around and posted, hope all is well.

Anyway, I have a potential new project that may be broken up into two parts:

1) Upgrade existing MDB to SQL Server 2000 and then use ADP as front-end.

2) Convert Access Forms to web-based (most likely PHP)

I'd prefer to do the data conversion from Access to SQL Server 2000, then go right to the web-based front-end, but the potential client wants to save financial resources by incrementing the process.

Anyway, has anyone had success using ADP in a LAN environment with a user base of 40 users with an average of 10 concurrent connections?

From what I've read and also past experience using ADP is that it's as clunky and cumbersome as using one MDB file. I've read that using Jet Engine 4.0 and putting the ADP in a shared resource in a centralized server can address some of the connection/access problems, but wanted to know if anyone has successfully implementing using ADP as a front-end to a SQL Server 2000 back-end?

Thanks in advance.
========================================
Buh Bye!

Cheers,
Me