ADP or MDB Front End

[kilt]

I'm upgrading our network to Small Business Server. At this moment in time we just use Access 97 as our database but as it's outgrowing, I'm upgrading to SQL Server Backend & Access 2000/2002 Front End. The problem is I don't know whether to use ADP or MDB front end. There will be a maximum of 15 people using the database through the Access front end & I was going to use ADP but I've read somewhere that this is only a single connection & I would have to link servers to enable other users? Can you suggest the best way, bearing in mind I do have time constraints (6 weeks max). Thanks in advance for your time.

Regards,
Kilt..

 

[cmmrfrds]

I am not sure what was meant by a single connection. It may be because the ADP program was running off a network drive, but if each user has a copy of the app it should be no problem.