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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.